Back to School Sale -
20% off all courses with code BTS2019
Search for courses or lessons
Redeem a coupon
Start free trial
How would you change the value of the Sales $ column of a PivotTable from Sum to Average?
Right click any cell within a Sales $ column in the PivotTable, choose Value Field Settings, and select Average.
Double click the value in the PivotTable, choose Value Field Settings, and select Average.
Right click the header for the Sales $ column in the PivotTable, choose Value Field Settings, and select Average.
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?
The Sales Units column of the source data is formatted as text.
Someone has already defined a Count of Sales Units column on the PivotTable and that format is being forced on the newly added column.
There is at least one text value somewhere in the Sales Units column of the source data.
How many times can we use the same field in the Values area of a PivotTable?
As many as we like.
Once per aggregation type.