Forum Discussion
New Items
Hi, I have data that has UPCs and sales data for them. My data is structured in a way that I have 4 times for data. Latest 4 weeks, latest 13 weeks, latest 26 weeks and latest 52 weeks and for ea...
Here it is....
I am guessing that "New" would be when latest 4, 13, 25 adn 52 weeks sales are indential?
| 1 | 77419.92 | SALES | CUR | LATEST 04 WKS |
| 1 | 357.09 | SALES | YAG | LATEST 04 WKS |
| 1 | 173597.4 | SALES | CUR | LATEST 13 WKS |
| 1 | 107383.2 | SALES | YAG | LATEST 13 WKS |
| 1 | 297050.3 | SALES | CUR | LATEST 26 WKS |
| 1 | 140625.6 | SALES | YAG | LATEST 26 WKS |
| 1 | 305715.5 | SALES | CUR | LATEST 52 WKS |
| 1 | 159647 | SALES | YAG | LATEST 52 WKS |
| 1 | 21564 | UNITS | CUR | LATEST 04 WKS |
| 1 | 123 | UNITS | YAG | LATEST 04 WKS |
| 1 | 49824 | UNITS | CUR | LATEST 13 WKS |
| 1 | 34003 | UNITS | YAG | LATEST 13 WKS |
| 1 | 91030 | UNITS | CUR | LATEST 26 WKS |
| 1 | 45082 | UNITS | YAG | LATEST 26 WKS |
| 1 | 93350 | UNITS | CUR | LATEST 52 WKS |
| 1 | 51497 | UNITS | YAG | LATEST 52 WKS |
| 1 | 15.74 | ACV MAX | CUR | LATEST 04 WKS |
| 1 | 1.21 | ACV MAX | YAG | LATEST 04 WKS |
| 1 | 11.86 | ACV MAX | CUR | LATEST 13 WKS |
| 1 | 11.7 | ACV MAX | YAG | LATEST 13 WKS |
| 1 | 11.06 | ACV MAX | CUR | LATEST 26 WKS |
| 1 | 9.12 | ACV MAX | YAG | LATEST 26 WKS |
| 1 | 5.88 | ACV MAX | CUR | LATEST 52 WKS |
| 1 | 5.45 | ACV MAX | YAG | LATEST 52 WKS |
Anonymous , Still not very clear to me
sales = calculate(sum(Table[value]),Table[Meausre]= "SALES" ,Table[Type] ="LATEST 04 WKS")
CUR = calculate(sum(Table[value]),Table[Meausre]= "CUR" ,Table[Type] ="LATEST 04 WKS")
new measure =SALES - CUR