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