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?
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
Right-click any cell within a 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
There is at least one text value somewhere in the Sales Units column of the source data
Someone has already defined a Count of Sales Units column on the PivotTable and that format is being forced on the newly added column
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
Back to the top
© 2019 GoSkills Ltd.
Skills for career advancement