Connect to the "Global Superstore" data source and use the Orders table.

Explanation:

Drop Order Date to columns, Category to Rows, and Sales to Text.

Go to Analysis -> Totals -> Show Columns Grand Total

Graphical user interface, text, application Description automatically generated

Update Total All Using to Average:

Graphical user interface, text, application Description automatically generated

Table Description automatically generated

In the year 2012, the furniture sales were more than the average sales of that year.