I would like to have a selector on my dashboard with some kind of logic (im attaching excel file and dashboard)
3 dimensions : Product, Priority and Campaign
1 metric: Amount
for a specific product if it exists Priority = Yes, i would only like to show in the campaign selector the Campaign where the priority=Yes
For example for Lemon, it only should show "summer" value in the campaign selector
If there is no Priority= Yes then it should show everything
For example Strawberry Product doesn't have Priority=yes and i want to show all the campaigns in the values of my campaign selector: Summer, Spring and Winter
how can i do that ? is it possible ?
One way to do this without creating a calculated field would be to place Priority on the filter shelf and select only Yes. Then, on the Campaign quick filter, right click on it and select Only Relevant Values.
Hope this helps!