What is it about actions that doesn't work for you?
I have reattached your workbook with Dashboard 2. Is this the desired functionality? If so, take a look at the actions of this page. For each Source Sheet, there is only 1 Target sheet (so that one worksheet won't effect them all). Hope this helps!
Sales.twbx.zip 33.0 KB
Thanks a lot for your reply. Your solution partially gives an answer to my problem.
Let me give another workbook to bring about the problem at hand.
There are 20 sales persons in Florida
Out of the sales persons in Florida, how many sell pens? Using the action, I can see that there are 9 sales persons in Florida selling pens.
Out of those 9 salesperson who are in Florida and sell pens, how many sales persons are in region A?
Now here comes the problem. Using actions, the answer to this question should be less than 9. But I get result for all figures in the third chart.
Similarly if I want to know, out of those people who are in Florida and sell pens and are in region A, how many sales persons sell calculators in region B?
I want to answer all the questions using actions.
Number of sales person.twbx.zip 29.8 KB