Hi,
I was wondering if the following is possible:
I would like to update my Brand filter to be grouped by the following:
- Our Brand ( a specific set of brands)
- DFA Brand ( a specific set of brands)
- Top 15 Brand (based on Top N by Volume Sales)
here's some dummy data:
| Group By | Brand | Category | Volume Sales |
| DFA Brands | D Brand | Category 1 | 10450 |
| DFA Brands | F Brand | Category 3 | 10000 |
| DFA Brands | A Brand | Category 1 | 9913 |
| Our Brand | Our Branded Apples | Category 1 | 12000 |
| Our Brand | Our Branded Oranges | Category 2 | 3200 |
| Our Brand | Our Branded Strawberries | Category 1 | 3500 |
| Top 15 Brands (by Volume Sales) | Our Branded Apples | Category 1 | 12000 |
| Top 15 Brands (by Volume Sales) | D Brand | Category 1 | 10450 |
| Top 15 Brands (by Volume Sales) | Blue Brand | Category 1 | 10200 |
| Top 15 Brands (by Volume Sales) | Pink Brand | Category 1 | 10100 |
| Top 15 Brands (by Volume Sales) | Yellow Brand | Category 1 | 9999 |
| Top 15 Brands (by Volume Sales) | A Brand | Category 1 | 9913 |
| Top 15 Brands (by Volume Sales) | Dog Brand | Category 1 | 9124 |
| Top 15 Brands (by Volume Sales) | Fox Brand | Category 1 | 8975 |
| Top 15 Brands (by Volume Sales) | Cat Brand | Category 1 | 8645 |
| Top 15 Brands (by Volume Sales) | Purple Brand | Category 1 | 8210 |
| Top 15 Brands (by Volume Sales) | Teal Brand | Category 1 | 7900 |
| Top 15 Brands (by Volume Sales) | Sheep Brand | Category 1 | 7000 |
| Top 15 Brands (by Volume Sales) | ABCD Brand | Category 1 | 6300 |
| Top 15 Brands (by Volume Sales) | EFGH Brand | Category 1 | 6000 |
| Top 15 Brands (by Volume Sales) | JKL Brand | Category 1 | 5000 |
