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?
Go to presentation tab select the dimension for which you need 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?
Retrieving data ...