2 Replies Latest reply on Jul 25, 2018 7:14 AM by Ankit Bansal

    Sum based on Custom range of months

    sirisha.siddiraju

      Hi,

       

      We have a user requiremnet to sum of revenue depends on months range.My fiscal year starts from april through march and we have three years of data.Example FY2018,FY2019,FY2020.

      So we need to calculate sum of revenue from custom month range sept to october as mentioned below.Can someone pls let us know how can we achieve this.

       

         

          

      to Sep-2018Oct-2018 to Sep-2019Oct-2019 to Mar-2020
      Sum(Revenue)Sum(Revenue)Sum(Revenue)
      Customer1

       

      Thanks