Please see the attached workbook > Dashboard 1.
Selecting 'Same Day' from the Furniture Shipmodes sheet should filter only the Customers that have Same Day Shipmode in the Category Sales Sheet. Currently it filters both Ship Mode and Customers. Is there a way where only the Customers are filtered in Category Sales sheet?
I have tried Selected Fields in Action Filter definition but since Customer Name is missing in both source and target sheets, I can't select only Customer Name. Can someone please help?
Thanks
Hi Nick Jastrzebski, Thanks for looking into my question. Currently the Action filter also applies Ship Mode = 'Same Day' to the Category Sales sheet. I am trying to avoid Ship Mode filter from being applied to my target sheet.
You can follow the these steps to see what I want to achieve
1. In Furniture Shipmode sheet, click 'Same Day', the Furniture Sales in the Category Sales sheet gets filtered and shows $39,149 Furniture sales
2. Now, if you drag and select all the filtered customers from the Customers sheet (in the top view)
3. Now Unselect 'Same Day' from the Furniture Shipmodes sheet, you would have filtered only the Same Day customers and the Furniture Sales in Category Sales sheet will be $212,107
This is what I am trying to achieve by only one Action Filter, without having to do this intermediate step of selecting individual customers.
I hope it helps clarify the issue.
