Hide column

[soniasweety]

Hi all,

i have a pivot table ..  i want to show only dimensions in the pivot table..  

so i added dummy measure   like   "1"   so its showing  as 1  in entire measure column   so i want to hide completely this measure column how to do this?

Thanks

[santhiqlik · Accepted solution]

Hi,

No need of adding dummy measure. Just uncheck "Suppress Zero values" in Presentation tab.  It will just show dimensions.

[soniasweety]

thank you its working