Hi All - I am a relatively new user for Tableau and new to this community so please bear with me. I have searched for the answer I am trying to find but didn't see what I needed. Its very possible i just didn't recognize an existing answer that would apply to me.
I have attached a basic version of a workbook I am trying to set up. I am trying to make it work with this simplified dummy data before i apply it to the real thing. The MasterData data source contains the sales records. The PromoProduct contains information about promotions that i want to use to filter the sales data. Each promotion has a name, store list, product list, and dates that define that promo. The dashboard currently has a couple of test graphs to test what i am trying to get to.
Sheet 1 is a summary of the filtered promotion. It shows the sales for the promotion based on the PromoProduct filters. I would like to add an in/out filter to the rows for stores that had the promotion versus stores that did not. The way it is currently set up, it shows the totals for all stores with the promotion. I'm trying to get a section below it that shows the same summary but for stores not defined in the promo.
Sheet 2 is also a filtering problem that I don't know how to solve. I would like the promotion name filter to control everything but the dates. I want the filter to change the products and stores but not the date. I'm trying to let this chart have an independent start/stop slider so i can see weeks before and after the promotion - not just during. It wold be great if the weeks defined in the promotion were a different color in order to distinguish the promo time.
Hopefully what i am trying to do makes sense and there is a solution. Thanks in advance for any help!
Test.twbx 52.1 KB