I currently have a pivot table that gives me the totals at the bottom for each column, however I also want totals for each row.
Is this possible?
Hi, I think it is not possible to show one expression in column and another in row wise. If we Pivot both the expression columns will be changed. Try using one expression with Calculated Dimension if possible.
I have 2 dimensions where you can pivot down and the 3rd Dimension going across, adding a calculated dimension,
unfortunately does not work.
Retrieving data ...