aggregate the column values

[soniasweety]

Hi all,

i have a column in pivot table     product%      it is showing % correct   

but i need to show that total      aggregating all columns values /no of rows   .  

how to achieve this?

[jonathandienst]

I suggest you post some sample data and your required output to better explain your requirements. Post as text, not as images and you will get more relevant and accurate responses.

[soniasweety]

HI Jontydkpi 

attached sample 

[sunny_talwar]

What is your expression that you are using for Product%?

[soniasweety]

Hi @sunny_talwar   

below is the used expression

=()

[sunny_talwar · Accepted solution]

May be try this

((Sum(Total(Aggr(fabs(sum(FC_QT)-sum(AP_QT)),ID)))*sum(AP_QT))/sum(total AP_QT))
/
Count(DISTINCT id)

[soniasweety]

its worked thank you 🙂