Hi all,
I am trying to figure this one out. I have a sheet which has a list of drop down of various codes. These codes are all linked to a store. These stores all belong to a certain district. Note i have the mapping all done in the back end. I want to create a chart so when i click on the drop down and select a store, depending on which district its in the relevant stores display in the graph a long with the store i selected.
For example if i select a store in NY i want all the stores in the NY area to display along with the store select so i can see how it compare to its relevant area.
how would i go about doing this?
store cid.PNG
ranking.PNG
Thanks!
Bookmarks