Calculate first 12 months qty sold since open date of a store

Ok yes I have worked up a solution around this scenario in the forum before

This is certainly not easy though and to solve it, there is a bit to it.

We can work on this, but need more information around you model, data, how you want to show the results etc.

All these things matter a lot when looking to solve this.

You’ll see in the forum post that it took a while to get to the end result but it’s definitely possible combining a few formula and model techniques.

We can work on something here, just send through more info.

Chrs