A pivot table would be an appropriate tool for each of the following actions except

Question content area bottom

Part $1$

A$.$

locating one specific sales transaction.

B$.$

calculating the average cost of each product model by plant location.

C$.$

calculating the total costs for each product model by month within a particular year.

D$.$

summarizing transaction data by store location.