Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I need help in a chart where I have to show the value and percentage of value on group total. I have attached the sample file. Presently percentage is showing only on 3 rows.
Hi,
Kindly check my solution.
Hope that helps.
Regards,
Mithilesh
Hi
But all the items not showing in the charts.
Regards
PKP
I would steer you away from Aggr() function as they take a toll on performance. You can try this expression:
Sum(Value)/Sum(TOTAL <Group>Value)
For the chart, you can try this:
Sum(Value)/Sum(Aggr(Sum(TOTAL <Group> Value),Group, Item))