Very well done! We can now create a new report type. It should look like this:

In other words, we want to see quarterly revenue values in the form of a table, with rows representing years and columns representing quarters. Such reports can help us see seasonal trends in revenue values. For instance, Q4 revenues are typically higher because of holiday shopping. It would be much harder to spot such trends when quarters are shown below each other.

How do we write such a query? Take a look:

SELECT
  DATEPART(Year, OrderDate) AS Year, 
  SUM(CASE WHEN DATEPART(Quarter, OrderDate) = 1
  THEN Amount ELSE 0 END) AS Q1,
  SUM(CASE WHEN DATEPART(Quarter, OrderDate) = 2
  THEN Amount ELSE 0 END) AS Q2,
  SUM(CASE WHEN DATEPART(Quarter, OrderDate) = 3
  THEN Amount ELSE 0 END) AS Q3,
  SUM(CASE WHEN DATEPART(Quarter, OrderDate) = 4
  THEN Amount ELSE 0 END) AS Q4
FROM Orders
GROUP BY DATEPART(Year, OrderDate)
ORDER BY DATEPART(Year, OrderDate);

In the query above, we grouped all rows by the DATEPART(Year, OrderDate) value. This is something we've done before. However, we also used SUM(CASE WHEN...) expressions in the SELECT clause. In this case, the SUM(CASE WHEN...) expression first checks the quarter of the given order (DATEPART(Quarter, OrderDate) = X). If the quarter value matches the value for the given column, the order's Amount is added. Otherwise, we add 0. This way, Q1 will only sum orders from the first quarter, Q2 will only sum orders from the second quarter, etc.