Video Create Pivottable And Analyze. With a PivotTable selected browse to the Analyze Change Data Source option. While a PivotChart shows data series categories and chart axes the same way a standard chart does it also gives you interactive filtering controls right on the chart so you can quickly analyze a subset of your data.
![1](https://i.pinimg.com/600x315/71/58/23/71582361000ece1555c95cab6ba4f1ac.jpg)
Ill select the Sales Revenue field since this is a numerical data type it is automatically added to the Values area. Right-click any cell in the Sum of Order Amount column. The recommended PivotTable feature offers a variety of one click options to analyze your data.
Formulas pivot tables macros VBA charts dashboards Power.
Im going to zoom in a little to make the PivotTable easier to read. Ill select the Sales Revenue field since this is a numerical data type it is automatically added to the Values area. And the numbers in the column are formatted as currency. For information about using multiple database tables see Create a PivotTable to analyze data in multiple tables.