How to hide dimention in Pivot Table

[Manlyhero]

Hi all, 

I am very new on qlik sense and my problem is I want to hide dimension from the pivot table but also want to keep one to many relations as showned in the image. Is there a way to do that? 

[Lisa_Sun]

On the chart property, select the dimension which you want to hide. Under "Text color expression", set this expression to make the text color to white.  

if([Field name]>0, white())

[Lisa_Sun]

[Manlyhero]

Thank you for you response but is there any alternative to completely disappear that column? Like dimension exist but in the background etc? Because in that case report will be like this

Also If I want to export the report as an excel field will appear as it is. 😕 

[Lisa_Sun]

If you want to hide the dimension but keep the pivot table hierarchy, you can set the expression for dimension and keep Null values. 

[Lisa_Sun · Accepted solution]

The expression same can be:  

=if(Customer<>'David',Customer)