Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all
I have had a request to move the column subtotals of a Pivot Table to the top, however this also moves the row subtotals to the left.
Does anyone know how I can move the column subtotals to the top yet keep the row subtotals to the right?
Thanks
the Pivot table has a fixed layout. its either (Top & Left) or (Bottom & Right).
Hi,
Go to presentation tab select the dimension for which you need subtotals.
Subtotals :
Check Subtotals On Top
the Pivot table has a fixed layout. its either (Top & Left) or (Bottom & Right).
Do you have any screenshot to show how exactly you want to display the content in the pivot table?