Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All ,
Is anybody can advice me about how i can get horizontal total (which will placed at the end of pivot table ) for my rows.
Any examples / Links ??
Bhushan N
Do you have any horizontal dimensions? If so, checking Show Partial Sums for those dimensions should put the totals on the right. To show Partial Sum, go to the Presentation tab of your chart and highlight the desired dimension. Then check Show Partial Sums.
If you don't have any horizontal dimensions, then the Partial Sums will always go below. In that case, I think you would need to manually create a Totals column. In this situation all of your expressions could be different, which is probably why there's no automatic method.
I've attached a simple example with two charts. One with the horizontal dimensions, the other without. I also changed it to Subtotals at top, which will put the subtotals at the top and left rather than bottom and right.