Hiding expression column in Pivot table

[Anonymous]

Hi,

Can anyone help in hiding expression column in pivot table. I have a pivot where I would like to hide expression columns and I tried in many ways but unable to resolve it.

[kamielrajaram]

Hi Shiva,

Have you tried creating a variable and setting it to 0 and in the condition of the expression type in vVariable = 1.

Kamiel

[buzzy996]

hope tis will works for u!

[Anonymous]

Thanks all for your responses.

We can not hide column in Pivot table. So I changed chart from Pivot to Straight to hide expression column. It is fine and working.

[buzzy996]

hi,the below example shared by me with pivot table,are u tried that?

[#6]

check the checkbox conditional and wrire condition 1>2

it will hide the expression column.