I'm not sure that I understand your question without a datasample to play with, but it sounds like a fun puzzle... do you have a dataset to play with?
Thanks for your response!
Basically I have 2 dimensions Merchant Vertical and Business name.
I have used merchant city to plot the data in filled map, Let say If I select particular merchant vertical ="Books" then map will only show all business under "Books" vertical, where if I select particular business name "Barnes and Noble" which is part of "Books" vertical then map will plot only for "Barnes Noble".
At this selection what I wanted to show is, I want to show business name related to "Books" vertical at the same time also wanted to show "Barnes and Noble" business in seperate color. The reason why we are doing this wanted to compare the sales of Barnes and noble with across all business under "Books" vertical. Since the data is more senstive that why I am not sharing, but if you still need data. Probably will share you the dummy data.
hmmm I don't really have an answer, but some ideas definitely. Also I'm really not good with filled maps or making up good data, so I've made a text sample to show how the different calculations filter, but please ignore the fact that cites and countries do not match haha.
In your description that you want to choose merchant first to filter then filter further by specific business, but that second filter should more highlight than filter... ? What I think you really want is parameters that are dependent on each other or filters that do not completely filter. Neither is possible I think.
However - depending on your data and how often the merchant/business combination changes, I did have a little play. I've made one parameter filled from a calculated field that combines Merchant and Business so you get a list. (which unfortunately needs to be refilled if more merchants or businesses are entered). I think it needs to be a parameter to be able to choose one and not filter on it automatically. Then I calculate colouring based on the following: if it is the chosen business plunk into one group, if it is not the chosen business, but still the same merchant plunk into another group, anything else goes to further groups in case this is necessary/wanted. That way if I choose Barnes & Noble, I see them highlighted, but every other shop is still on the map.
I've also created a filter to ask if you want to filter everything by merchant - if so, then anything that is not from the same merchant as the chosen business is set to show "No" and filtered out.
Does this help you further?
Books.zip 32.1 KB