0,1 should be selectable through list box

[Anonymous]

Hi ,

In pivot table for no data i need to show 0 instead of '-' symbol and also in list box need to show 0,1.

when i select 0 in list box need to show 0 vales in pivot table and for 1 selection also need to show 1 values in pivot table.

Thanks,

Yuvrajesh

[khalander]

yep... It is similar...

Your script is perfect because in my script some manual work is there...

[Anonymous]

Thanks Manish working fine..:)