5 Replies Latest reply on Aug 30, 2016 11:40 PM by Kashish Chauhan

    Average Order Value calculation & Trend Line for Top X customers

    Burak Tansug

      Hi,

      I have a list of about 1,000 customer accounts and I am trying to put a trend line for Top X customers at different intervals (say Top 20 customer avg order value, say Top 100 customer avg order value, etc).

      Is this an LOD formula?

      I tried an IF statement but I don't think that will work.

       

      Any help would be greatly appreciated.

       

      Thanks

      Burak