Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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...
Need Help
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    edhans 

     

    Here it is....

     

    I am guessing that "New" would be when latest 4, 13, 25 adn 52 weeks sales are indential?

     

    177419.92SALESCURLATEST 04 WKS
    1357.09SALESYAGLATEST 04 WKS
    1173597.4SALESCURLATEST 13 WKS
    1107383.2SALESYAGLATEST 13 WKS
    1297050.3SALESCURLATEST 26 WKS
    1140625.6SALESYAGLATEST 26 WKS
    1305715.5SALESCURLATEST 52 WKS
    1159647SALESYAGLATEST 52 WKS
    121564UNITSCURLATEST 04 WKS
    1123UNITSYAGLATEST 04 WKS
    149824UNITSCURLATEST 13 WKS
    134003UNITSYAGLATEST 13 WKS
    191030UNITSCURLATEST 26 WKS
    145082UNITSYAGLATEST 26 WKS
    193350UNITSCURLATEST 52 WKS
    151497UNITSYAGLATEST 52 WKS
    115.74ACV MAXCURLATEST 04 WKS
    11.21ACV MAXYAGLATEST 04 WKS
    111.86ACV MAXCURLATEST 13 WKS
    111.7ACV MAXYAGLATEST 13 WKS
    111.06ACV MAXCURLATEST 26 WKS
    19.12ACV MAXYAGLATEST 26 WKS
    15.88ACV MAXCURLATEST 52 WKS
    15.45ACV MAXYAGLATEST 52 WKS
    • amitchandak's avatar
      amitchandak
      Super User
      6 years ago

      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