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

[SatyaPaleti]

Hi  Adam Could you Plz send me the saved app. I think in pivot table we cant check partial sum for expressions i guess

[#3]

it is showing attached to my reply at 2:30 today

[#4]

Satya

Have you recieved it or been able to get it?  If not if you could provide an email, I will send direct

[SatyaPaleti]

Thank you Adam, still i have not received could you please forward to satyapaleti@gmail.com

[#6]

Satya

I received your email that you did receive my qvw with subotals but it was not what you are looking for.  My udnerstanding was you are looking for reaks at the capacity level by business types? - see attachment - if that is not the case, if you can mock up a sample of the pivot and what you are trying to achieve, I would be happy to see if I could assist further