Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all, I have i pivot table with a expression that is a CONCAT.
I want to hide the subtotal of that concat, but i don't know how to do that.
Can someone help me?
Option total mode is disabled.
Best regards
First, figure out the Dimensionality of the subtotal. Add Dimensionsality() as an expression. The highest level subtotal is 0 and it goes up from there. If you have a few dimensions, your data would probably be Dimensionality() 3 or something. Once you know the dimensionality of the subtotal, then do something like:
If(Dimensionality() > 2, Expression, ' ')
That will evaluate on your data and any subtotals after the first three dimensions (I believe). Modify that number until you get the results you want. I did a space in the false section of the If, because I don't want the null character in my chart, but instead a blank.
One work-around (not the ideal way) is to custom format that cell to have the background color and font color as the same.
I know that this is not the correct way to do - but is a quick thing, till you find the right way.