Frequently Asked Questions

• Right-click in the Values field. Point to Summarize Data By, and then click the summary function you want to use.

• To switch back to SUM, right-click again in the Values field, point to Summarize Data By, and then click Sum.

You can also show values as a percentage of the total by using a custom calculation.
1. Right-click in the Values area, point to Summarize Data By, and click More options.


2. Click the Show values as tab, and then select a function in the Show values as list and Click OK



3.To return the values to a normal view, follow the same steps, and then click Normal.