We have a Pivot Table with 3 dimensions, one of them placed in the X axis (TYPE LICENSE), and 3 expressions (Cars, Drivers and %), two of them shared by all dimension values, and a third one "%" which we only want to show for ONE of the values (TOTAL).
We wonder how we can hide the % column for all values except "total" (please, consider it as a dimension value, not calculated by "show partial sum"). We have achieved to leave as NULL these columns, but not hide them.
I'm trying to hide the columns using the CONDITIONAL option and expression "ColumnNo() <> FieldIndex('COD_TYPE_LICENSE','TOTAL')", but the function ColumnNo() is not returning any value when I use it in CONDITIONAL option (althought yes in metric expression).
Is there any way to hide an expression column for some dimension values?
It doesn't work. I forget to say that my "TOTAL" column is a Dimension value, it's not generated by "Show partial sum" of Pivot Table. For this reason, I can't use dimensionality, it's the same in all cases.