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.
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.