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

# Quarter to Quarter report

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 Q2 Q1 Q3 Q4 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% GP 36.48% 179.31% 171.65% -46.88% PW -58.76% -67.26% 104.71% 54.43%
• ###### 1. Re: Quarter to Quarter report

Hi Tony,

I don't know why you exclude part of quarter  but does this help?

Thanks,

Shin

• ###### 2. Re: Quarter to Quarter report

Hi Shin,

Quarters 1, 2 and 4 are what I was expecting. All the sales values on previous year sales in quarter 3 should be in current year sales. I have attached a spreadsheet to show the values.

Thank you

Regards

Tony

• ###### 3. Re: Quarter to Quarter report

Difficult to speculate, but guessing this logic?

Thanks,

Shin

• ###### 4. Re: Quarter to Quarter report

Hi Shin,

Thank you for the quick response! This is perfect

Regards

Tony

• ###### 5. Re: Quarter to Quarter report

HI Tony,

You are welcome , but not sure about the timing/trigger of changing "current" period.

Shin