Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I would first check the presentation tab and check the Partial some for the Dimension/expression where you would like to see totals
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
Go to Style and check "Indent Mode"
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
Hi Adam We cant do Partial Sum for Expression. I have Checked Partial sum for both dimensions but I unable to get Total
Hi Sebastian Pereira, I Checked "Indent Mode" in Style. It's not getting Thank you, Satya
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)
Thank you Adam could you please send me that
you should ahve it by now - if not please let me know