6 Replies Latest reply on Oct 12, 2019 12:27 PM by Olalekan Agboluaje

    Previous month sales calculation

    Olalekan Agboluaje

      Hi,

       

      I need help calculating previous month value please. I have attached a sample workbook for reference.

       

          Expected  result

      Monthend DateSalesPrevious month sales
      1/1/2019126,5910
      2/1/201986,377126,591
      3/1/201997,05986,377
      4/1/201995,04697,059
      5/1/201998,48695,046
      6/1/201982,47898,486
      7/1/201979,03382,478
      8/1/201984,79279,033
      9/1/201982,87484,792
      10/1/201921,46682,874

       

      Also, in the attached workbook, when all Month are selected, the previous month should be the Max (month) -1

      and when a particular month is selected the previous month should be Selected month - 1

       

      Thanks for your help on this

       

      Kin regards

       

      Ola