Hi All:
I have a store performance report with about 120 rows of data spread across about 40 columns. I use t Drop Down list to select the specific store I want to look at (there's 80 stores).
The report relies on several WHATIFS to select the right data for the right store, and it works perfectly. But now I want to look at district performance (there are 7 districts). The raw data is only at the store level.
The only way I can think of doing it is to add a column to my raw data that identifies the district to which each store belongs, then add another WHATIFS to look for that condition.
Is there an easier or more efficient way to do this?
Thanks in advance.
I have a store performance report with about 120 rows of data spread across about 40 columns. I use t Drop Down list to select the specific store I want to look at (there's 80 stores).
The report relies on several WHATIFS to select the right data for the right store, and it works perfectly. But now I want to look at district performance (there are 7 districts). The raw data is only at the store level.
The only way I can think of doing it is to add a column to my raw data that identifies the district to which each store belongs, then add another WHATIFS to look for that condition.
Is there an easier or more efficient way to do this?
Thanks in advance.
