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

Answer 1

Double-click the value 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

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

Answer 4

Don’t know

Answer 5

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

Answer 6

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

Answer 7

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 8

Don’t know

Answer 9

Once per aggregation type

Answer 10

As many as we like

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?