Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I would to know if it's possible to hide a specific value of a dimension in a pivot table.
Assuming that I have a dimension FlagStatus which has 2 values : debtors and creditors.
I want to hide the debtors value in the display but the total of the dimension gives me the total of both value. Is it possible to do so ?
So the total expression should be something else than the expression for dimension values immediately above? Seems difficult for end-users to interprete...
Hi Patrick,
In Color Text of expression
If(Dimensionality() > 0,
If(FlagStatus='debtors',ARGB(0,0,0,0)))
Regards
I hope the image above could explain more
I don't see your Dimensions
In Text Color :
If(Dimensionality() >0,
If(Dim1='Value1' and Dim2='Value2',ARGB(0,0,0,0)))
Or in case of Dimension, the same in text color of Dimension.
I have tried to replicate your example.
See attachment
Thanks for your reply. but this is not exactly what I want.