Hi all,
I have a requirement on calculating the YTM of (the sales Quantity of a Product/the sales quantity if the shop has the Product A)
|
| 1 | A | S1 | 2 |
| 1 | A | S2 | 3 |
| 1 | B | S1 | 5 |
| 2 | B | S2 | 2 |
| 2 | B | S1 | 1 |
| 2 | A | S2 | 1 |
| 3 | B | S1 | 3 |
| 3 | A | S2 | 1 |
| 3 | B | S1 | 7 |
For example, the Product = A,then the result:
Month 1:
(2+3)/(2+3+5)=0.5
Month 2:
1/1+2=0.5
Month 3:
1/1 =1
YTM = 0.5+0.5+1 =2
How to use expression to calculate above scenario?
Sum({<Product = {"A"},[Month] = {"<=$(=Num(Month(monthstart(max(Month)))))"} >}[Sales Quantity])
/
Sum({<Shop = p({1<Product = {'A'}>}Shop),[Month] = {"<=$(=Num(Month(monthstart(max(Month)))))"}>} [Sales Quantity])
The expression in above is incorrect.
The result will be:
2+3+1+1/2+3+5+2+1+1+3+1+7
Best Regards,
Louis
