Hiding null value at dimension level in Pivot table

[sarfaraz_sheikh]

Dear All,

In my below image i do not want   below Delhi in Ergo_loc as dimension..However i want to show blank values column like FNon_contactable ,ELead_pending without underwriter  ..but i do not want in Ergo_loc...I tried but failed..

Kindly help if any solution ....My qvw is also attached here for your refernece ...

Sarfaraz

[#2]

Sorry. My bad.. I did not see the issue properly.

[priyarane]

Not able to understand your requirement properly.

[sarfaraz_sheikh]

Dear ceprew, 

In this format there is Two dimension 1> Ergo_loc  2>  Status_Description

My requirement is very clear i.e  i want to keep the 0 values column  according to status description...but do not want to keep the null blank as per Ergo_loc

The below screeshot will clear every doubt..  I want like below!

I dont want like below screeshot.

just want to remove the blank record appearing in Ergo_loc dimension .........do not want to remove blank recored as per status description .......

Sarfaraz

[sarfaraz_sheikh]

hi gwassenaar  please comment !!!!!!

Sarfaraz

[priyarane]

Hi Sarfraraz,

In the dimension tab there is option 1. check surpress when null values and 2. Presentation Tab - Null symbol Value: -(Remove this), Missing Symbol: - (Remove this)