How can I hide the column in Pivot table

[AndersLiu]

[GaryGiles]

In the properties panel of your pivot table, look for the option of "Show column if".  In the expression box for "Show column if", you could use something like this:

=if(not isnull(expression),1,0)

Replacing expression with the expression for the measure.  In this way, if the values are Null, the column will be hidden.

[AndersLiu]

Thank you GrayGiles,This Colum expression need to display  in one categories。But in my  structure it has display  in four categories。

And my expression:

Pick(Match(BrandColumn ,'Evolution Index')

,MaxString({<[Market.Product]={$(vNonVBPBrand)}>}[Target EI])

)