Robert Jones is a manager of several sales organizations at Global Bike Inc. and his responsibilities are monitoring and managing sales activities. He has a number of OLTP systems to assist with the recording of day-to-day transactions. At the end of each month, he is provided with a report which displays each sale. The format of the report is illustrated below. Although this report provides a lot of information, the information is not in a format that can easily assist in the type of decisions you are required to make. Robert has decided to examine the PivotTables as means of producing more useful reports.
By doing that answer following questions: 1.What product was sold the least number of units, for all countries, all years?
2.What product category provided the most revenue in 2011. for all countries? 3.What percentage did the off-road bikes contribute to the overall bicycle sales quantity, for all countries, all years? (round to one decimal place!) 4.In which city was this percentage the highest? 5.Bicycles and accessories are more likely to be bought in spring and summer as in fall and winter time. Find which product is an exception to this rule, for all countries, all year
Sample Solution