Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Expets,
Total is appearing twic in Pivot table.
Note:
its in Indent mode
Subtotal is appied on one dimension only
as attached
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.
Is there any way to move out those
Yes, disable the Indent mode and don't enable the Partial Sums option for the rightmost dimension.
Ok,
So atleast can we make it to the top. Attached one should come up not at bottom