Hi all! I am calculating the sell through rate of a product.
Right now, I have weekly sales and inventory data.
The formula of the rate is the sales quantity divided by the inventory of the last week.
However, I don't know how to write the expression of the measures.
I have tried the following but it won't work:
SUM(Sales)/SUM({<[Date]={[Date]}-7>}Inventory)
Please help solve! Thanks in advance!!
p.s. This is the expected answer:
Date | Sales | Inventory | Sell Thru |
7/1/2017 | 6 | 54 |
7/8/2017 | 1 | 21 | 2% |
7/15/2017 | 3 | 53 | 14% |
7/22/2017 | 6 | 21 | 11% |
7/29/2017 | 4 | 66 | 19% |
8/5/2017 | 7 | 53 | 11% |