4 Replies Latest reply on Jul 13, 2018 10:25 AM by Deepak Rai

    Sum If month = XXX and changes when new information is added

    Tina Crouse

      I am having a bit of a time with a calculation. I have months beginning with January 2016 to present. Every month when I refresh the data I will get the next month. For example, right now I have June 2018. In August when I refresh I will get July 2018.

       

      I want to show my max date number of records and at the same time the prior 2 years so it would be like

       

      June 2016                    June 2017                   June 2018

      13000                            15000                          17000

       

      When I refresh next month based on the calculation it will change to

       

      July 2016                      July 2017                    July 2018

      Whatever the sum of the number of records are for those months.