Macro for hidding column in pivot table?

[Anonymous]

Hello,

I have a requirement

I want to hide an expression in the pivot table.Though this can be done in straight table as it has hide option, but pivot does not have this option.

I'm attaching a sample qvw, in that i want to hide the column sum(amount).

I know this can be done using macros..could someone add the mcaro to the file I'm attaching.

Note: I don't want to use button to show or hid, i want to hide this column permanatly.

I'm using qv 11 edition

Thnx

B

[Anonymous]

Jeff,

  Excellent, there are so many different ways of doing the same thing..in Qlikview..thank you Jeff

Regards

B