Hello and welcome to the last part of our course. Previously, we learned to create reports showing revenue values across different periods. In this part, we'll extend that knowledge by learning how we can compare revenue for various categories. Comparing multiple categories is just an example – the aim of this part is to teach you how you can compare various segments of your business. The same rules apply to comparing revenue from multiple departments or cities.

In this part we'll learn how to extend the revenue reports we discussed in previous parts to show revenue across multiple categories. First, we'll create reports showing total revenue in a given period of time in multiple categories:

We can also extend this report to show what percentage of the total revenue is made by each category. An example report can look like this:

Next, we'll learn how to compare revenue in multiple periods of time across multiple categories. This example report shows the revenue in 2016, 2017, and 2018: the total revenue and revenue for the beverages and seafood categories:

As we did often, we'll learn how to show the delta (difference) between the periods instead of the revenue:

If we want to show revenue for many categories, it's convenient to "flip" the report to show time periods as columns and the categories as rows:

Are you ready?