Pivot table turning on/off subtotals per expression
Hi guys,
I have a pivot table with several dimensions and expressions. I am using the subtotals function which shows the totals for every expression used in the pivot table. But some expressions subtotal doesn't makes sense, or not needed for analysis. Is there a way to turn on/off subtotals for each expression? If the answer is yes, then how?
You can't turn them off. But you can try using the dimensionality() function to make the text transparent. Click on the + sign in front of the expression, select Text Color and enter an expression like =if(dimensionality()<>3,black(),white(0)). Change the 3 to the value that's appropriate in your chart. See attached example.
You can't turn them off. But you can try using the dimensionality() function to make the text transparent. Click on the + sign in front of the expression, select Text Color and enter an expression like =if(dimensionality()<>3,black(),white(0)). Change the 3 to the value that's appropriate in your chart. See attached example.
