How would you change the value of the Sales $ column of a PivotTable from Sum to Average?

Answer 1

Right click any cell within a Sales $ column in the PivotTable, choose Value Field Settings, and select Average.

Answer 2

Right click the header for the Sales $ column in the PivotTable, choose Value Field Settings, and select Average.

Answer 3

Double click the value in the PivotTable, choose Value Field Settings, and select Average.

Answer 4

Don’t know

Answer 5

The Sales Units column of the source data is formatted as text.

Answer 6

Someone has already defined a Count of Sales Units column on the PivotTable and that format is being forced on the newly added column.

Answer 7

There is at least one text value somewhere in the Sales Units column of the source data.

Answer 8

Don’t know

Answer 9

As many as we like.

Answer 10

Once per aggregation type.

Answer 11

Don’t know

When you drag the Sales Units column to the Values area of your PivotTable it shows up as “Count of Sales Units”. What is the most likely cause?