calculations the Pivot table Sector Task 3(a): Consumer Discretionary Materials Telecommunications Services Utilities Grand Total Average of

calculations the Pivot table

Transcribed Image Text:

Sector Task 3(a): Consumer Discretionary Materials Telecommunications Services Utilities Grand Total Average of Count of TransactionID Qty Average of UnitPrice Sum of Total Dollar Value 4,084 6,593.22 $107.13 $2,830,446,980.00 1,457 6,582.48 $70.41 224 7,036.50 $30.53 $665,594,594.00 $47,919,093.50 1,407 6,363.70 $48.52 $431,155,769.50 7,172 6,559.86 $85.78 $3,975,116,437.00 Sector Task 3(a): Consumer Discretionary Materials Telecommunications Services Utilities Grand Total Average of Count of TransactionID Qty Average of UnitPrice Sum of Total Dollar Value 4,084 6,593.22 $107.13 $2,830,446,980.00 1,457 6,582.48 $70.41 224 7,036.50 $30.53 $665,594,594.00 $47,919,093.50 1,407 6,363.70 $48.52 $431,155,769.50 7,172 6,559.86 $85.78 $3,975,116,437.00