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

[sarfaraz_sheikh]

kindly reply if know the solution ..........

Sarfaraz

[pokassov]

Hello!

Can you change ERGO_LOC as dimension to calculated dimension

=if(IsNull(ERGO_LOC),' ',ERGO_LOC)

with lable

ERGO_LOC ?

[sarfaraz_sheikh]

did not work ....have observation in below image...

sarfaraz

[awhitfield]

The - values are actually 'MISSING rather than 'NULL'

Andy

[sarfaraz_sheikh]

Dear Andrew,

How to suppress that missing ....any help would be more appreciated

Sarfaraz

[awhitfield]

If you tick 'Populate Missing Cells' on the presentation tab they will appear as blank instead of -

[sarfaraz_sheikh]

dear anderw ,

id did not work .......want to hide missing cell ....

sarfaraz

[pokassov]

I don't get what you want...

[#10]

Hi,

Please check 'Suppress when value is null' for ERGO_LOC dimension. It should work.