Totals in Pivot Table

[nareshthavidishetty]

Hi to all,

Actually i need to show the totals in pivot table on right side of the table and it should be give me row level total.(Not sub totals at bottom or top .PFA for sample excel data source for the workouts .

or

[Digvijay_Singh]

In presentation tab, for State dimension, apply partial total ( after dragging State from vertical to horizontal) as shown below.

[satishkurra]

Small correction, Its Partial Sum and not Partial Total in presentation tab of Chart Properties for PIVOT Table

Thanks

Satish

[Digvijay_Singh]

Thanks for correction Satish!