How do you show both Column and Row totals in a pivot table. In the presentation tab, "Show Partial Sum" seems to always be grayed out when there ismore than one dimension.
always the partial sum is only for dimensions. If you want to get sum for expressions, you have to enter a new expression and sum here all columns like:
Only works for dimensions you can enable the show partial sums for as many dimensions as you want. On the presentation tab select the dimension one by one to check the 'show partial sums'
If you have a dimension as columns you can have a horizontal total
If you have a dimension as row you can have a vertical total.
If you have more than one expression and want to sum them, you need to write an expression for this.
Hmm...the issue Im having is in a pivot table, all of the information I need summed is in one field. In the pivot, the different identifiers from the given field are the column headers. I need to sum the values across so each of the column headers creates a new column called total.
If the rows are dates and the column headers are Products, how do I sum across so I get a total for a single date?
That makes perfect sense, but the issue I am experiencing is that in the presentation tab, when I go to select show partial sum, it is not allowing me to select it. The box is grayed out and uncheckable
