Connect to the "Global Superstore" data source and use the Orders table. Find out in which year the furniture sales were more than the average sales of that year?
Options:
A.
2012
B.
2013
C.
2014
D.
2015
Answer:
A
Explanation:
Explanation:
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.
Graphical user interface, text, application
Description automatically generated
Graphical user interface, text, application
Description automatically generated
Table
Description automatically generated