How to set analysis in YTM with calculation

[Anonymous]

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)

Month	Product	Shop	Sales Quantity
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

[Anonymous]

Thank you very much!

I will make it asap.

Many Thx!