As He Prepares His Assignment for His Marketing Class, Ted

Multiple Choice

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.