John also wants to determine his company's average sales? How does he do this?
What will be an ideal response?
John has two options.?1) He can right-click the cell that says "Sum of Sales," then point to Summarize Values By in the shortcut menu. Here, he sees Sum has been selected as the default summary function. John clicks Average and the cell he right-clicked now reads "Average of Sales."?2. John also can make this change to the summary function by clicking the Field Settings button in the Active Field group on the PivotTable Tools Analyze tab.
You might also like to view...
The security manager position is much more general than that of the CISO.
Answer the following statement true (T) or false (F)
A company with an existing business relationship with a consumer may call the consumer for up to how long after the consumer's last purchase?
A. 12Months B. 18months C. 24 months D. There is no limit so long as there is an existing business relationship