Hide columns/rows from pivot table based on condition
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.