How to hide a column in pivot table ,that column is used to evaluate in another expression?

[jasasri_90]

Hi ,

I want to hide a column in pivot table,which i have used to evaluate another expression For example

Header 1	Header 2
sales	commison
10000	500

another column which is based on sales value something like sales/2.

but i don't want to show the reference column sales in my pivot table?

Need help.

Thanks.

[sunny_talwar]

May be this can work

Pivot Column Width to Zero

[Siva_Sankar]

How to Hide an Expression Field in Pivot Table | Qlik Community

[jasasri_90]

Thank you for your reply.

I am just curious is there any other way with out using macro.

[Siva_Sankar]

Hi Jasasri,

Check this one Hiding an expression in pivot table and my document on hiding columns in pivot table using macro.

Hiding Dimensions in Pivot Table

-Siva

[jonathandienst]

>>I am just curious is there any other way with out using macro.

Not as far as I know. This macro needs only be fired manually once during development, so the normal cautions about macros don't really apply. Think of this as part of your development toolkit.