I want to be able to select all of these options on a cover sheet which i have created with data validation so that when a combination of these 8 elements are selected it spits out the data i need:
<tbody>
</tbody>
I want it to basically spit out a table of the sales data (value and units with growth by brand) using the dataset i have in a different tab which looks like this (just 1 line of the data -there are 30,000 items):
<tbody>
</tbody>
I managed to make it work through creating combinations and a helper sheet when i only had 3 options (brand, major category and category) but now there are too many options and we are looking at thousands of combinations so can't do it... any help?
Thanks so much
| Date |
| Total Market |
| All Major Categories |
| All Brands |
| All Categories |
| All Subcategories |
| All Genders |
| Including Set |
<tbody>
</tbody>
I want it to basically spit out a table of the sales data (value and units with growth by brand) using the dataset i have in a different tab which looks like this (just 1 line of the data -there are 30,000 items):
| SKU | Date | Spend | Customers | Transactions | Units | BRAND | MAJOR CATEGORY | CATEGORY | SUBCATEGORY | GENDER | Colour | MASS /PRESTIGE | Petrol/Non Petrol |
| [101650444] | 2016 6 - June | 8.74 | 1 | 1 | 2 | A | Cars | 4 wheels | SUV | Female | Black | Prestige | Petrol |
<tbody>
</tbody>
I managed to make it work through creating combinations and a helper sheet when i only had 3 options (brand, major category and category) but now there are too many options and we are looking at thousands of combinations so can't do it... any help?
Thanks so much
