Suppress column in Cross Tab

I have a simple cross tab like
x y z
a 10 20 30

b 40 50 60

c 20 30 40

I want to suppress the column Z. I did right click on the measure in the crosstab and went to format field and in the suppress formula typed the following.

column header = “z”

I don’t see the column z getting suppressed as I still see that. Can some one tell me where I am going wrong?

Thanks


BIuser58 (BOB member since 2006-12-01)

why can’t you apply filter to exclude “z”?


Mahi (BOB member since 2004-07-22)