How to get Percentage Total?

[MuraliPrasath]

Hi,

I've a table, and I'm using Subtotals on Top of the table but I'm not getting the totals for Percentage field (%)  column.

[sunny_talwar · Accepted solution]

Try this if you need to see a Avg % as total:

Avg(Aggr(yourExpression, yourDimension))

Replace Avg with Sum if you want to see the Sum up top.

Please note that Aggr won't work, if you are using expression label or Column function. You will need to use the actual expression which calculates that percentage.

HTH

Best,

Sunny

[MuraliPrasath]

thank you sooooo much.