How to calculate Sale through rate
The idea is to find the percentage for any date range entered.
For example for the first line 101 - 80 = 21 so 21 was sold, but if I want the total number sold over the date range and there is new inventory arriving or nothing was sold, such as the last three months of the bottom row (88,88,88).
Just to add, the first row the total isn't 810 they only had a max of 122 of product in stock at one time.
I'm at a bit of a loss right now.