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![Eek! :eek: :eek:](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
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