Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Pivot Table sub total and grand total

Hi Dear friends,

Here in the pivot table   how to create subtotal and grand total .

Thanks in advance,

Bunny

2 Replies
settu_periasamy
Master III
Master III

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 %]))

Anonymous
Not applicable
Author

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.