A solution to last week's challenge can be found here. 
In this week's challenge explore the reporting tools to help Arnold create a visualization for his car sales last month.
Arnold at Platinum Motors would like to get a better picture of his car sales from the last month. Using the provided dataset, create a report that shows the locations of the buyers, color-coded by the type of car purchased, with a legend. Underneath the report, put a table that shows the number of sales and average sale price by car type.
Spoiler
i know it's not hard to transpose and crosstab, but I just use my own macro "Transpose (Excel Style)" to accomplish it one step without any real configuration.
As someone who actually does report vehicle sales for a living, this one hits a little close to home.
