RockandGrohl
Well-known Member
- Joined
- Aug 1, 2018
- Messages
- 810
- Office Version
- 365
- Platform
- Windows
Third time's a charm...
Let's say I have a set of data as below:
What I want to do this the follow with an advanced filter:
I want to see people who have bought either "FamilyFun" or "Sports", which I can do like this:
Now, what if I want to see the following:
Brochure_Region <>0
Last_Booked >42000
Last_Booked <44000
OptIn_NH_LandMail <>0
And then on top of that, show me people who have bought either Family Fun or Sports?
If I do this, it does not filter anything.
I hope this makes sense - there's kind of a "top line" filter that's happening, which I want to happen over and above anything else. Then, filter the product categories on an "or" basis.
Cheers.
Let's say I have a set of data as below:
| Brochure_Region | Last_Booked | OptIn_NH_LandMail | FamilyFun | UK | Sports | Events | EU | Showtime |
| B1 | 42803 | 1 | 1 | 3 | 0 | 0 | 0 | 0 |
| A6 | 42721 | 1 | 1 | 0 | 0 | 0 | 1 | 0 |
| C2 | 43808 | 1 | 1 | 1 | 0 | 0 | 0 | 0 |
| C3 | 42480 | 0 | 0 | 1 | 1 | 0 | 0 | 0 |
| A6 | 43582 | 1 | 2 | 19 | 0 | 3 | 1 | 0 |
| A3 | 43566 | 0 | 0 | 0 | 3 | 0 | 0 | 0 |
| A5 | 43797 | 1 | 1 | 2 | 0 | 1 | 0 | 0 |
| A3 | 43649 | 1 | 2 | 9 | 0 | 4 | 1 | 3 |
| A3 | 43728 | 1 | 3 | 15 | 3 | 2 | 35 | 1 |
| A3 | 44243 | 0 | 2 | 1 | 0 | 0 | 0 | 0 |
| A3 | 43554 | 1 | 0 | 49 | 2 | 1 | 0 | 7 |
| A6 | 43936 | 1 | 1 | 0 | 0 | 0 | 0 | 0 |
| A3 | 42978 | 1 | 1 | 0 | 0 | 0 | 0 | 0 |
| A5 | 42475 | 1 | 2 | 3 | 0 | 0 | 0 | 0 |
| C2 | 42463 | 0 | 0 | 0 | 1 | 0 | 0 | 0 |
| C2 | 43526 | 1 | 1 | 0 | 0 | 0 | 0 | 0 |
| A3 | 43510 | 1 | 0 | 0 | 1 | 0 | 0 | 0 |
| A5 | 43601 | 1 | 1 | 0 | 0 | 0 | 0 | 0 |
| A3 | 43311 | 1 | 2 | 0 | 0 | 0 | 0 | 0 |
| C2 | 43159 | 1 | 1 | 0 | 0 | 0 | 0 | 0 |
| B1 | 43400 | 1 | 0 | 0 | 0 | 0 | 0 | |
| A3 | 43796 | 1 | 1 | 4 | 0 | 0 | 0 | 2 |
| B1 | 43351 | 0 | 1 | 1 | 0 | 0 | 0 | 0 |
| B1 | 43881 | 1 | 1 | 6 | 0 | 1 | 2 | 0 |
| A5 | 42587 | 1 | 1 | 0 | 0 | 0 | 0 | 0 |
| C1 | 43430 | 1 | 2 | 0 | 0 | 0 | 0 | 0 |
| D2 | 43836 | 1 | 1 | 4 | 0 | 0 | 3 | 0 |
| A3 | 42565 | 0 | 1 | 0 | 0 | 0 | 0 | 0 |
| A2 | 43661 | 1 | 0 | 0 | 3 | 0 | 0 | 0 |
What I want to do this the follow with an advanced filter:
I want to see people who have bought either "FamilyFun" or "Sports", which I can do like this:
| FamilyFun | FamilyFun | Sports | Sports |
| >0 | <1000 | ||
| >0 | <1000 |
Now, what if I want to see the following:
Brochure_Region <>0
Last_Booked >42000
Last_Booked <44000
OptIn_NH_LandMail <>0
And then on top of that, show me people who have bought either Family Fun or Sports?
If I do this, it does not filter anything.
| Brochure_Region | Last_Booked | Last_Booked | OptIn_NH_LandMail | FamilyFun | FamilyFun | Sports | Sports |
| <>0 | >42000 | <44000 | <>0 | ||||
| >0 | <100 | ||||||
| >0 | <100 |
I hope this makes sense - there's kind of a "top line" filter that's happening, which I want to happen over and above anything else. Then, filter the product categories on an "or" basis.
Cheers.
