Total at the end of row

[#1]

Good day

Is it possible to have to totals shown at the end of the pivot table instead of having it at the top or bottom.

So instead of sum on the column total i want to sum on the row total.

Thank you

Stuart

[#2]

You can create a new expression with a Sum of each column.

[trdandamudi]

In the Pivot chart in "Presentation tab", select your dimension and check "Show Partial Sum"

To show total as the bottom:

Select "Subtotal at Bottom" under Subtotals

[sunny_talwar]

Yes you can, you need to add the 'Show Partial Sum' on the Consultant dimension on the presentation tab