Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Dear friends,
Here in the pivot table how to create subtotal and grand total .
Thanks in advance,
Bunny
Hi,
Try the below expression in your performance column,
if(Dimensionality()=0,
Avg(Aggr(Avg(([Passed / Collected 2015]/[Total/ Analyzed])/[Target %])*(Sum(CLP)/Sum(TOTAL CLP)),Query3.Water_System))*2,
Avg(([Passed / Collected 2015]/[Total/ Analyzed])/[Target %]))
Hi yeah its working for the particular qv file but i m having a large huge data there this logic not working .. i m trying to solve it.