ELIMNATE A COLUMN PIVOT

[eduardoheres]

Hi again,

Do you know how to eliminate a column for a dimension in a pivot?

because i calculate a variance between scenarios but in first scenario my variance is all zero and i want to elimante that part.

attached is a screen shot

the yellow one is what i want to elimanate

regards

[Lisa_P]

You can use the Show column if condition and use an expression to hide the column based on this condition such as only show column if sum(VS)>0. This is found in the properties panel, Data and the measure value, Show column if ..

[eduardoheres]

can you send me an example please i cant do it 😞

[Lisa_P]

sum(VS)>0 into Show column if

[eduardoheres]

thank you but i cant see the option  😞

[eduardoheres]

i cant see the option do you know why?