A sales manager for an auto dealer has created a PivotTable showing monthly sales as the column labels and the automobile models as the row labels. However, the raw data that the table is based on has many more columns that list out whether or not each model has certain features, such as satellite radio or four-wheel drive. The sales manager would like to show the company’s owner how filtering out certain options affects the sums of sales. What should the sales manager do in order to present the owner with a PivotTable in which the owner can most easily filter certain vehicle options in or out to see buyer demands for those options?
A The sales manager should create slicers for each option that should be filtered and let the owner click within those slicers.
B The sales manager should create a collection of PivotTables that each use different vehicle options in the Report Filter section.
C The sales manager should place every vehicle option in the Report Filter section and show the owner how to open the different filters.
D The sales manager should place a vehicle option in the Row Labels section instead of the vehicle model and let the owner try different options as the row labels.