3 Replies Latest reply: Sep 22, 2016 11:22 AM by Matthew Quinn RSS

    Show last 6 months results based on current selection

    Matthew Quinn

      Hi there,

       

      I want to display the last 6 months number of deliveries in a straight table.

       

      e.g. I have currently selected AUGUST 2016 - It should show me the selected month, and the 5 months previous to that with it.

      Month           Num Del.  

      February     400
      March630
      April700
      May340
      June920
      July778
      August1000

       

      If the selected month is February For example, it should be able to look back to the previous year also.

      e.g.

      September200
      October989
      November223
      December967
      January443
      February400

       

      As the examples show, the number of deliveries is the number recorded for each month, not accumulative.

       

      Thanks for any help.