![]() ![]() 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: Learn about the calculation methods that are available, how calculations are affected by the type of source data, and how to use formulas in PivotTables and PivotCharts. PivotTables provide ways to calculate data.
0 Comments
Leave a Reply. |