Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to add Column Totals in pivot table?

Hello,

I recently created a pivot table, with several columns with numerical values. Here is a screenshot:

PivotTable.png

I was wondering how I can show the total values for each column in the pivot table? I am able to get totals or average in a straight table, but I don't see the option to do this in the pivot table. Thank you in advance for your assistance!

12 Replies
shraddha_g
Partner - Master III
Partner - Master III

In VOB use expression as

Sum(Aggr(VOB expression, [Invoca campaign],[Promo Number],[Created Date],[Closed Date],Month))

P.s - Use correct field names according to your data model

Anonymous
Not applicable
Author

Hi, Can someone please help me!

I am trying to add the column total for the below, the first three column total appears but the fourth one does not. Do you know how to resolve this? thank you

TOTALS ON PVOT COLUMN.JPG

chiranjeevialapati
Contributor
Contributor

Very nice Information. Please let me know is it possible to display column totals at the end instead of beginning.