Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a standard pivot table with two dimensions. I have horizontal subtotals for one dimension, and by default these appear on the right. However, the table is quite wide, and therefore I want the subtotals to appear on the left (i.e. the beginning of the table). Is this possible?
Do you mean that your subtotal is in a column which subtotals columns to the left?
If so, go to Presentation tab in Chart Properties. If you change the SubTotals from bottom to top, subtotal should move from right to left
Joe
Do you mean that your subtotal is in a column which subtotals columns to the left?
If so, go to Presentation tab in Chart Properties. If you change the SubTotals from bottom to top, subtotal should move from right to left
Joe