1. As a risk assessment procedure, plot a monthly revenue trend to get an overall feel for the sales trend for 2018 only.

• Drag and drop Invoice Total (in Measures section) to the Rows line.
• Drag Invoice Date (in Dimensions section) to the Columns line. This presents revenue by year.
• Press the + sign next to YEAR in the Columns line, then press + next to QUARTER.
• Remove YEAR and QUARTER from the Columns row. This now displays total sales (note the SUM next to Invoice Total in the Rows line) by month for the entire sample period.
• To only include 2018s data, drag Invoice Date to the Filter panel.
• Double-click on Year, check 2018, and press Apply.
• Save tab as 2018 Revenue Trend.

What three months had the highest sales in 2018?

Multiple Choice

• September, October, and November

• March, September, and October

• January, February, and July

• May, June, and December