How to filter my region in my pivot table?

[bhaveshp90]

Hello,

How can I filter the region to show only 'NA' and 'EU' in my pivot table excluding 'China' and 'ASEAN'?

I'm using the following condition as of now?

               = if(not WildMatch(Region,'China','ANZ-ASEAN'), Region)

It is filtering but I am getting a new value '-' in my region as shown below.  How to get rid of this?

thanks

Bhavesh

[m_woolf · Accepted solution]

In Chart Properties|Dimensions, check Suppress when NULL

[groveliam]

^

[bhaveshp90]

thank you, it worked for me