Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
swathimgumte
Contributor
Contributor

Pivot table subtotal issue

@hi Folks,

I want the subtotals of the pivot table to be shown only if the values in the dimension row is more then one,

if only one row is there then the sub total row should show.

for eg( refer the image attached) i want to show total row if i have both ICATM & USI in second column.

if i have either of the one then the subtotal column should not show.

Message was edited by: swathii gumte Added sample qwv @SunnyTalwar

Message was edited by: swathii gumte Updated sample doc with reduced data

10 Replies
swathimgumte
Contributor
Contributor
Author

You did it sunny...!

its working perfect as per the requirement.

Thanks a lot...