Count is the default function for data other than numbers. The Count summary function works the same as the COUNTA function. This is the default function for numeric data. To calculate the value fields, the following summary functions are available for all types of source data except Online Analytical Processing (OLAP) source data. For example, one data marker would represent, by its position on the vertical (value) axis, the total sales for April in the North region.
A Values field named Sum of Sales could contain data markers that represent the total revenue in each region for each month.
The Month field could be a series field that shows the items March, April, and May as series represented in the legend. In a PivotChart, the Region field might be a category field that shows North, South, East, and West as categories. The value at the intersection of the April column and the North row is the total sales revenue from the records in the source data that have Month values of April and Region values of North. The Region row field provides the items North, South, East, and West.
In the PivotTable, the Month column field provides the items March and April. If you create a PivotChart from the data in a PivotTable, the values in that PivotChart reflect the calculations in the associated PivotTable report. Produces the following PivotTables and PivotCharts. Summary functions in value fields The data in the values area summarize the underlying source data in the PivotTable. To calculate values in a PivotTable, you can use any or all of the following types of calculation methods: