Hide columns/rows on pivot table based on conditions

Neeti

Hi,

 

I was working on pivot table and was wondering that, is there anyway that we can hide columns/rows based on condition or data selection from other card on the same dashboard?

Suppose, I have value column in my table for all countries. I want to see for a particular brand display only those rows/coulmns where the value is more than zero. And hide all other.

 

PFA screen shot to get a clear picture.

Please let me know if such thing can be implemented currently.

 

Thanks,

Neeti