Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
May be this can work
Thank you for your reply.
I am just curious is there any other way with out using macro.
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
>>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.