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 🙂
Hi Gayle
Why don't you post some sample data together with what you have done so far.
This will help us to understand your needs better.
Sunny
Thanks Sunny I was hoping to avoid having to de-sensitise the data as even a small amount will take a bit of fiddling but I'll go ahead and do that and upload when I've finished 🙂
Hi Sunny,
Sample workbook attached and there is a text box describing what I want to achieve.
Thank you for your help 🙂
Gayle
Hi Gayle
From your raw data, the PT looks OK when sliced although I did notice that the Store ID slicer is not connected to PT1.
Store ID 2000 and 5000 are not available for 2018-07 but they are available for 2018-08 and 2018-09.
Are you selecting a single or multiple items from the YYYY-MM slicer?
If you can let us know what did you slice and what you expected the result to be then we can have a clearer picture.
From what I have tested everything looks fine.
Maybe I don't quite understand your question.
Sunny
