As he prepares his assignment for his Marketing class, Ted goes to his friend Carter for help with PivotTables because Carter has had a lot of experience with them in his job.
-Ted wants to use his PivotTable to show the total value of the motorcycles for a series of motorcycle dealerships but he wants to filter the display to show only those dealers whose total stock of motorcycle is greater than $1 million.How would he accomplish this?
A)He would develop a PivotTable using the aggregate filter.
B)He would develop a PivotTable using the report filter.
C)He would develop a PivotTable using the category filter.
D)He would develop a PivotTable using the value filter.

Question

Quizplus · Accepted Answer

Ted should use the value filter in the PivotTable to filter the dealerships based on the total stock value of motorcycles, allowing him to display only those with a total value greater than $1 million.

As He Prepares His Assignment for His Marketing Class, Ted