Filter slicer from and to dates and only include data that appears in both the starting date thru to ending date possible?|General Excel Questions & Answers|Excel Forum|My Online Training Hub

Hi All 🙂

I will try to explain clearly what I am trying to achieve and I'm not even sure if it is even possible!

I have a several years of data of store sales by item by month and I can summarise the totals for a spread of dates using the slicer filter which can then show overall % increase/decrease for the period for all stores. What I want to do is only include stores that were open for the entire time that is chosen in the slicer filter. This then allows for a more accurate % measure of overall sales increase. Naturally the store status of open/unopened at any given spread of dates can change. I am open to any suggestions using helper columns, calculated fields, additional tables whatever you creative lot can suggest please 🙂 I am reasonably good with pivot tables but a complete novice with power pivot tables. I am happy to use power pivot solutions if you would be kind enough to give me step by step instructions on how to go about it.

Thanks everyone 🙂