Hi,
I'm trying to create a report that will allow me to select the location from a List, And then the WEEK, and then it populates the fields based on some formula. I know it has to do with Indexing, i believe, but I haven't been able to make it work yet.
I want Sum(TotalRev), Sum(profit), Sum(goals) to be populated by selecting The store, then Week. It should then see the data for that time period, sum it, and populate the cells. Weeks need to be set Monday through Sunday. Is that possible?
I've attached the sheet, and the cells that should contain the lists are highighted in yellow, the cells that should populate, in green.
Thank you very much for your help.
Bookmarks