asked on May 12, 2023
In the attached report is there a way to have the % of County column not total? It shows at 1,2000 % which we do not want.
⋅ May 15, 2023
Hello, David!
Thank you for reaching out to us.
We suggest using the "percentofparentrowtotal" aggregation for the "% of County" measure. Using this aggregation, each percentage is counted based on the parent. The subtotal values for "County" rows would be percentages from a 100% grand total, and the values from "Source of referral" rows would be percentages of the corresponding subtotal, the same as on the attached image. You are welcome to check the JSFiddle example: https://jsfiddle.net/flexmonster/73Ledzjs/
Please let us know if using "percentofparentrowtotal" aggregation works for you.
Best Regards,
Maksym
⋅ May 23, 2023
Hello, David!
Hope you are doing well.
We are wondering if you had time to check the proposed solution with the "percentofparentrowtotal" aggregation.
Please let us know if it worked for you.
Best Regards,
Maksym
⋅ May 24, 2023
Let me ask the developer if he had a chance to try it.
⋅ May 25, 2023
This did fix our issue. Thank you!
⋅ May 25, 2023
Hello, David!
Thank you for the reply.
We are glad to hear that the proposed solution worked.
Feel free to contact us if more questions arise.
Best Regards,
Maksym
