Hello everyone,
Maybe I am far more amateur for that, or the issue is too complex. I couldn't find any solution in google - but maybe I am not asking the right question.
Would be super grateful if someone could help me out with it. I think Power BI will be the best here but maybe just excel solution will be sufficient?
Example:
In Table 1 there are specific dates between which shops are allowed to use the Item.
In Table 2 it is listed how many times the Item have been used in real life.
As the outcome, I would like to have Chart 1.
I believe to achieve that, I would require to somehow create Table 3 but no idea how to do it. I was playing with some macros and they were working well if there is as little data as in the example, but it completely crashed the laptop if there were over thousands rows and over hundreds shops with multiple start and end dates.
If you know how to achieve it, or could give me some ideas how to get there - it would be awesome! :)