Pivot Table - Total

[priyarane]

Hi Expets,

Total is appearing twic in Pivot table.

Note:

its in Indent mode

Subtotal is appied on one dimension only

as attached

[Gysbert_Wassenaar]

Well, that's how Indent mode works. If there's only one value of the rightmost dimension for the second rightmost dimension you get a subtotal for each detail row.

[priyarane]

Is there any way to move out those

[Gysbert_Wassenaar]

Yes, disable the Indent mode and don't enable the Partial Sums option for the rightmost dimension.

[priyarane]

Ok,

So atleast can we make it  to the top. Attached one should come up not at bottom