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:
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?