How to hide the column in pivote table in Qv11

[#1]

Hi All,

Please give your suggestiuons for above mentioned subject.

Please find below chart and i want to hide the Zero/ Null buckets in the pivote table. with out disturbing the total count.

2). In bucket 1to 5 days and 6 to 10 days , 11 to 15 days but 6 to 10 days , 11 to 15 days two buckets are hidden due to there is no data but i want to show all buckets

Please help me on the two problems

[Anonymous]

Hi

try like this goto properties -->presentation-->Uncheck Suppress Zero values

and check Show all values in Dimensions tab

Hope this might help you

Thanks

[Anonymous]

Hi,

keep the expression as >0 in the expression level

[#4]

Hi

thx for yoyr reply

but its not working.

[#5]

Hi,

Can you please give with example.

is there any macro to hide the column ?

[#6]

You have use sonething like "value + 0.0000000001" in expression when not need to hide columns, and set "Number" option for that expression to round displayed value.