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: 
brijesh1991
Partner - Specialist
Partner - Specialist

Pivot Table total not proper

Hi all,


I had a pivot table like this containing two dimentions Region and Campain and one expression: count(case): As shown in attached image: I had take horizonal total by checking show partial sum for Campain Dimention. But this total is not coming perfect. For example: for Guj, it shoud come 30, but in my application it's not 30. all the '?' indicates invalid total.
Is this a pivot table bug or can you please help me out??
Best Regards, Brijesh

1 Solution

Accepted Solutions
brijesh1991
Partner - Specialist
Partner - Specialist
Author

Hi All, I detected the problem. By default, Pivot table has Total Mode: Expression Total. But I wanted 'Sum Of Rows' Total Mode. Now anyone please tell me how to change that total mode from 'expression total' to 'Sum of Rows'??? Brijesh

View solution in original post

2 Replies
brijesh1991
Partner - Specialist
Partner - Specialist
Author

Hi All, I detected the problem. By default, Pivot table has Total Mode: Expression Total. But I wanted 'Sum Of Rows' Total Mode. Now anyone please tell me how to change that total mode from 'expression total' to 'Sum of Rows'??? Brijesh

Gysbert_Wassenaar

You'll need the aggr function. Something like this:

=sum( aggr(yourexpression, Region, Campaign))


talk is cheap, supply exceeds demand