Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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)
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.
HI Jontydkpi
attached sample
What is your expression that you are using for Product%?
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)