1 Reply Latest reply on Jun 28, 2018 12:38 PM by Mavis Liu

    How to show completed Quarters and individual months

    Sergio Quintanar

      If I have data that ranges from July 2017 to July 2018, what do I need to do so that I can show completed Quarters (July to September, October to December & January to March), but include April as a single month. So in the attached workbook, I could represent the following:

       

      Q1=240

      Q2=218

      Q3=200

      April = 82

       

      Then one month from now, show Q1, Q2, Q3 but with the months of April and May individually. Then when I need to report on the whole year, I would show totals for Q1, Q2, Q3 and Q4.

       

      I have attached a workbook with dates. Also, would it be possible if YAGO was added so that in the above example, I could calculate the YAGO for Q1, Q2, Q3 but with the months of April as well?