There are two reasons for that.
1. As per your requirement, you want to show all the products. So, the previous approach is not letting me do that.
2. Generally, we look for the customers in a particular time frame such as how many customers in that year or month. This formula checks whether a customer has purchased in a particular month or not for that year.
1 of 1 people found this helpful
There may be another way to do that --
both in-elegant and demanding
a special behaviour from a user -- namely,
using a "Header-as-Button" on a dash.
User initially selects the Customers on the Filter,
then clicks the "Exclude Products" Header,
and gets the result (rest of the Products) beneath.
Please find the attached as an example.
This is pretty cool - could you explain how you managed to build this?
The Source (Sheet 7a) is built
with the [Product Name] pill on Details.
So by clicking on the "Exclude Products" Header
(of the dummy blue pill on Rows) a user is selecting
all Marks on a view, and the Filter Action is configured
to send the [Product Name] values of all Marks selected
from the Source (Sheet 7a) to the Target (Sheet 7b).
The next step is to go to the Target (Sheet 7b)
after the Filter Action has been performed
and set the resulting Action Filter (Set) on Filters
to actually Exclude the [Product Name] values being selected.
That would do the trick.
That's very clever - thank you!
Leanne, you're welcome.