Total in Pivot Table

[SatyaPaleti]

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

Above is Straight Table

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

[#2]

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

[SatyaPaleti]

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]

Go to Style and check "Indent Mode"

[#5]

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]

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

[SatyaPaleti]

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

[#8]

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]

Thank you Adam could you please send me that

[#10]

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