Aggregation Help in Chart

[pkpandey]

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.

[mithilesh17 · Accepted solution]

Hi,

Kindly check my solution.

Hope that helps.

Regards,

Mithilesh

[pkpandey]

Hi

But all the items not showing in the charts.

Regards

PKP

[sunny_talwar]

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)

[sunny_talwar]

For the chart, you can try this:

Sum(Value)/Sum(Aggr(Sum(TOTAL <Group> Value),Group, Item))