2 Replies Latest reply on Aug 23, 2016 7:31 AM by Marco Peters

# Quarter Over Quarter Difference As a Percentage

This topic has partially been discussed in previous posts, but I couldn't work it out and apply it for my specific problem. I need to create a table that looks like this (please see below), showing

1. % difference from current quarter to previous quarter (same year)

2. % difference from current quarter to same quarter (previous year)

Any idea how this could be accomplished?

Any help would be highly appreciated.

Thanks,

Marco P.

• ###### 1. Re: Quarter Over Quarter Difference As a Percentage

Create calculated fields for all of the 3 quarters above.

Q1 2016 = IF YEAR([Month/Year]) = 2016 AND DATEPART('quarter',[Month/Year])= 1 THEN [Sales] END

Amend that formula for the other quarters.

Then create calculated fields for your % difference fields.

Your QonQ formula would be: SUM([Q22016])/SUM([Q12016]) - 1

The end results looks as follows:

• ###### 2. Re: Quarter Over Quarter Difference As a Percentage

Awesome, Thank you very much.