5 Replies Latest reply on Jul 19, 2018 11:47 AM by Shinichiro Murakami

    Quarter to Quarter report

    Tony Smith

      Can someone please help me with the query below.

       

      The fiscal date starts on the 1st of March every year.  I want to display 4 quarters based on the BBCA fiscal year and BBCA fiscal period.

       

      The four quarters based on the BBCA fiscal year are as follows:

       

      March to May - Q1

      June to August  - Q2

      September to November - Q3

      December to February - Q4

       

      The report should show the current quarter which is  Q2 (Jun 2018 to Aug 2018).  It should also show Q1 for this fiscal year (Mar 2018 to May 2018), as well as  Q3 and Q4 of the previous fiscal year (Sept 2017 to Nov 2017 and Dec 2017 to Feb 2018).

       

      I also want to compare the data from the quarters above with data from the corresponding quarters from the previous fiscal years - Q1 (Mar 2017 to May 2017), Q2 (Jun 2017 to Aug 2017), Q3 (Sept 2016 to Nov 2016) and Q4 (Dec 2016 to Feb 2017).

       

      I have attached a spreadsheet to illustrate what I am trying to achieve.

       

      Thanks

       

      Regards

      Tony

                                                                                

      THIS IS THE   INFORMATION I WANT TO DISPLAY IN THE REPORT
      Q2Q1Q3Q4
      Mc L2% Different (QoQ)% Different (QoQ)% Different (QoQ)% Different (QoQ)
      AP-1.00%-7.18%44.02%-27.02%
      DTW-2.88%-63.44%-14.98%-46.46%
      GP36.48%179.31%171.65%-46.88%
      PW-58.76%-67.26%104.71%54.43%