2 Replies Latest reply on Sep 23, 2018 10:54 PM by Gavin Wong

    Calculate between 2 LODs

    Gavin Wong

      HI community

       

      i am trying to calculate the LODs between current years average sales to last year's  average sales.

      However i tried to create a calculated field to just have 2017's data... i simply couldnt do it.

      eg. 2017's average sales for customer segment vs 2018 average sales per customer segment.

       

      Need them in 2 separate calculated fields as they will need to be used elsewhere.

       

      My objective is to use the average sales per order (total sales / unique order id) in 2018 for each segment, compare it against the entire 2017 average sales at the year level as a %. (ignoring segments in 2017)

       

      any thoughts ?