Hide a value of a dimension

[#1]

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 ?

[Peter_Cammaert]

So the total expression should be something else than the expression for dimension values immediately above? Seems difficult for end-users to interprete...

[antoniotiman]

Hi Patrick,

In Color Text of expression

If(Dimensionality() > 0,

If(FlagStatus='debtors',ARGB(0,0,0,0)))

Regards

[#4]

[#5]

I hope the image above could explain more

[antoniotiman]

I don't see your Dimensions

In Text Color :

If(Dimensionality() >0,

If(Dim1='Value1' and Dim2='Value2',ARGB(0,0,0,0)))

[antoniotiman]

Or in case of Dimension, the same in text color of Dimension.

[antoniotiman]

I have tried to replicate your example.

See attachment

[#9]

Thanks for your reply. but this is not exactly what I want.

[#10]