Business Unit | Cluster | Country | Category | Subcategory | Segment | Market | Sector | SubSector | Brand | Productnumber | Sales | Turnover | Cost | Profit | Turnover per piece | Cost per piece | Profit per piece |
Europe | UK & Ireland | Ireland | Fastfood & Drinks | Refreshments | Burgers | Events | Festivals | Outdoor | OYT | 123 | 100 | 2000 | 750 | 1250 | 20,00 | 7,50 | 12,50 |
Europe | UK & Ireland | Ireland | Fastfood & Drinks | Fast Food | Soda | Events | Festivals | Outdoor | TB | 456 | 175 | 1500 | 1000 | 500 | 8,57 | 5,71 | 2,86 |
Europe | UK & Ireland | Ireland | Fastfood & Drinks | Refreshments | Soda | Events | Festivals | Outdoor | RTD | 789 | 225 | 1750 | 1200 | 550 | 7,78 | 5,33 | 2,44 |
Europe | UK & Ireland | United Kingdom | Fastfood & Drinks | Refreshments | Soda | Events | Festivals | Outdoor | OYT | 123 | 300 | 500 | 250 | 250 | 1,67 | 0,83 | 0,83 |
Europe | UK & Ireland | United Kingdom | Fastfood & Drinks | Fast Food | Burgers | Events | Festivals | Outdoor | TB | 456 | 550 | 375 | 135 | 240 | 0,68 | 0,25 | 0,44 |
Europe | UK & Ireland | United Kingdom | Fastfood & Drinks | Refreshments | Soda | Events | Festivals | Outdoor | RTD | 789 | 600,5 | 1255 | 700 | 555 | 2,09 | 1,17 | 0,92 |
Europe | CEE | Cyprus | Variety Sauces | Refreshments | Soda | Events | Festivals | Outdoor | OYT | 147 | 50 | 100 | 50 | 50 | 2,00 | 1,00 | 1,00 |
Europe | CEE | Cyprus | Variety Sauces | Fast Food | Burgers | Events | Festivals | Outdoor | TB | 258 | 25 | 75 | 45 | 30 | 3,00 | 1,80 | 1,20 |
Europe | CEE | Cyprus | Variety Sauces | Refreshments | Soda | Events | Festivals | Outdoor | RTD | 369 | 35 | 120 | 35 | 85 | 3,43 | 1,00 | 2,43 |
Europe | BNL | Belgium | Variety Sauces | Sauces | Sweet | Home | Summer | Mild | OYT | 741 | 500 | 8000 | 4000 | 4000 | 16,00 | 8,00 | 8,00 |
Europe | BNL | Belgium | Variety Sauces | Sauces | Sweet | Home | Summer | Hot | TB | 852 | 800 | 12000 | 5500 | 6500 | 15,00 | 6,88 | 8,13 |
Europe | BNL | Belgium | Variety Sauces | Sauces | Sour | Home | Summer | X-treme | RTD | 963 | 250 | 3500 | 2750 | 750 | 14,00 | 11,00 | 3,00 |
<tbody>
</tbody>
Selection | Dropdown | Selection | Dropdown | Selection | Dropdown | ||
Business Unit | Europe | Business Unit | Europe | Business Unit | Europe | ||
Cluster | UK & Ireland | Cluster | UK & Ireland/CEE | Cluster | UK & Ireland/CEE | ||
Country | United Kingdom | Country | United Kingdom/Cyprus | Country | Ireland/United Kingdom/Cyprus | ||
Category | Fastfood & Drinks | or | Category | Fastfood & Drinks | or | Category | Fastfood & Drinks |
Subcategory | Refreshments | Subcategory | Refreshments | Subcategory | Refreshments | ||
Segment | Soda | Segment | Soda | Segment | Soda | ||
Market | Events | Market | Events | Market | Events | ||
Sector | Festivals | Sector | Festivals | Sector | Festivals | ||
SubSector | Outdoor | SubSector | Outdoor | SubSector | Outdoor | ||
Brand | RTD | Brand | RTD | Brand | RTD |
<tbody>
</tbody>
So what do I want to do?
Based on my non-unique brand name filter my (financial) data ( productnumber to Profit per piece) based on various header criteria
As an example for my criteria please see the various selection tables. The selection will be done by a dropdown list. I have a formula that makes the row data in the table unique (till brand).That will be the source data for my dropdown
The result of the filtering will become the base for a vlookup.
The path that I want to follow preferably is BU -> Cluster->Country-> Category->Subcategory->Segment->Market->Sector->Subsector. The users for this will be people with minimal excel skill. The will just make a selection and get the output. So I want to make this as simple as possible.
I can do this with slicers BUT I can’t make a dropdown list out of my slicer criteria or I don’t know how.
What is the best way to do this?
Thanks in advance.