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.
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.
Hope you are doing well.
We are wondering if you had time to check the proposed solution with the
Please let us know if it worked for you.
Let me ask the developer if he had a chance to try it.
This did fix our issue. Thank you!
Thank you for the reply.
We are glad to hear that the proposed solution worked.
Feel free to contact us if more questions arise.