lost_in_the_sauce
Board Regular
- Joined
- Jan 18, 2021
- Messages
- 128
- Office Version
- 365
- Platform
- Windows
My data set is categorized by store/metric/month, with store in column A, metric (sales, cogs, payroll, etc) in column B. C1-N1 is Jan-Dec, and everything below that is numbers pulled from a tab that contains a data export from Smartsheets. Column A & B repeat enough that there is every possible store/metric combo.
I'd like to have another tab that has a lost of every store in columns with all the metrics in the rows that will populate/reorder high to low based on 2 drop down boxes - one for month and one for metric.
Is this possible? I've been stumped trying to engineer it.
I'd like to have another tab that has a lost of every store in columns with all the metrics in the rows that will populate/reorder high to low based on 2 drop down boxes - one for month and one for metric.
Is this possible? I've been stumped trying to engineer it.