An analyst needs to compare monthly sales, year over year, based on when an order...

Google Looker-Business-Analyst Question Answer

An analyst needs to compare monthly sales, year over year, based on when an order was created, as shown in the exhibit.

How should the analyst, in addition to selecting the measure Total Sales build the report?

Select the dimension Created Month, and pivot on the dimension Created Year.

Select the dimension Created Year, and pivot on the dimension Created Month.

Select the dimension Created Month Name, and pivot on the dimension Created Year.

Select the dimension Created Year, and pivot on the dimension Created Month Name.

Looker-Business-Analyst PDF/Engine

Get 65% Discount on All Products, Use Coupon: "ac4s65"