Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
SatyaPaleti
Creator III
Creator III

Total in Pivot Table

Hi Folks,

I am having huge data in pivot table.I want to show total for the data

For Example:-

I am having Dimensions:- Capability, Business Type

I am having Metrics      :- Asset

I want to display Total sum of Asset at Bottom of Pivot table.

In Straight Table we can see Total and Scroll bar at the same time.

In Pivot table also I want to see Total and Scroll bar at the same time How can we do this

Straight_Table.JPG

Above is Straight Table

Pivot_Table.JPG

Above is Pivot Table.

Please Find the attached docs for more details. Could you please help me in resolving this Issue

Thank you,

Satya Paleti

14 Replies
Not applicable

I would first check the presentation tab and check the Partial some for the Dimension/expression where you would like to see totals

SatyaPaleti
Creator III
Creator III
Author

Yeah I have done with that step. I have check partial sum for Dimension/Expression but it showing at complete bottom of the pivot table until we scroll down the bar till end. Actually i want to show scroll bar and Total at same time

sebastiandperei
Specialist
Specialist

Go to Style and check "Indent Mode"

Not applicable

Have you done it for each dimension/expression?  It is not an option that applies to all if it is checked - have to do it for each dimension/expression individually

SatyaPaleti
Creator III
Creator III
Author

Hi Adam We cant do Partial Sum for Expression.  I have Checked Partial sum for both dimensions but I unable to get Total

SatyaPaleti
Creator III
Creator III
Author

Hi Sebastian Pereira, I Checked "Indent Mode" in Style. It's not getting Thank you, Satya

Not applicable

I just reloaded your data and set partial sum and get totals the way you are expecting.  I will save the app and send it back

Partial sum is checked for all 3 (2 dimensions and 1 expression)

SatyaPaleti
Creator III
Creator III
Author

Thank you Adam could you please send me that

Not applicable

you should ahve it by now - if not please let me know