Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Thank you for your answers!
BR,
T
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.
As Gysbert says, no not a real way to turn them off unfortunately, oh how I wish there was!
Thanks Gysbert, it works!