Forum Discussion
Post PatronSlicer to filter data
That i believe is impossible. What you could do is create a slicer with just the option "Yes" and name it show vendor only or something.
When yes is not selected it will show all the Yes and no's.
Option 1: Change all the 1's to Yes and 0's to No and use that as a slicer.
Option 2: Use a bookmark and a button. Where in the bookmark it filters the correct data.
Btw, if default is No i would expect all the sales without showroom vendor, not just all the sales.
nleuckAnonymous
The problem is defaulting to "No" only shows products that are not showroom vendors. What I'm creating is more of an exclusion. I need "No" to show all products and "Yes" to exclude those products that are showroom vendors. I'm not sure how to go about it. The users are very specific on wanting it to be a slicer. I brought up bookmarking it and that was a no.
That i believe is impossible. What you could do is create a slicer with just the option "Yes" and name it show vendor only or something.
When yes is not selected it will show all the Yes and no's.