rpas rules doubt
Hi All,
I need your help for the below calculation.
subclass | sku1 | sku2 | |
calendar | sales | sales | sales |
1/1/2016 | 12 | 1 | 3 |
2/1/2016 | 13 | 2 | 5 |
3/1/2016 | 14 | 3 | 6 |
4/1/2016 | 15 | 4 | 8 |
5/1/2016 | 16 | 4 | 2 |
6/1/2016 | 17 | 6 | 1 |
7/1/2016 | 18 | 7 | 5 |
8/1/2016 | 19 | 4 | 2 |
9/1/2016 | 11 | 8 | 9 |
Now I need to find out calendar position where sales total is >=50 for subclass using tssum
Also then find out the respective tssum value for sku1 and sku2 using that calendar position
I have found below way to do so but not sure if it's correct.
subclass sales measure subsales --> (day_scls)
sku sales measure skusales --> (day_sku) ,total --> agg, repl --> spread
threashhold value measure threshld --> (day_scls) ,naval-50
date for start the sku startdate --> (day_sku) type -->date