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: 
Not applicable

Total not accurately reflecting in pivot table

Hi all,

I have a pivot table with a calculated dimension to only show certain important variables (an if(match) and then manual selected variables. This has worked however, the pivot table now shows totals including the values that I have hidden. Is there any way I can adjust these totals to just show the values I selected.

Thanks

6 Replies
sunny_talwar

May be try using Sum(Aggr()) function to fix the totals

Sum(Aggr(YourExpression, YourChartDimensions))

Not applicable
Author

Thanks Sunny, I've tried that and it gives me the correct number but I can't reflect it as the bolded total at the bottom of the table.

sunny_talwar

Can you share an image of what you are seeing?

Not applicable
Author

Below is what it shows normally when I don't have the selections in the box to the left.

Here is what I want the totals to show:

The ones selected are the only ones in the box because I hid the others ones

sunny_talwar

I think you need to check 'Suppress When Value Is Null' on the dimensions tab. See if that fixes your issue....

Not applicable
Author

That did it. Thank you very much!!