1 Reply Latest reply on Oct 4, 2018 4:44 AM by meenu choudhary

    Summing the last 3 "active sales date"

    jackyyeefa.tang

      Hi all,

       

      I have a data source whereby the sales do not necessary occur everyday. But then I will need a calculated field whereby it will sum the 3 latest 3 "active sales date", and find an average.

       

       

      I.e. If the latest sales I made was on 1st Sep, 27th Aug, 15th Aug, then Iwant to sum these 3 dates sales figures.

       

       

       

      Want a table like this with "last 3 days sales" = 12

       

       

       

      Regards,

      Jacky