Respuesta :
You can change the calculation used in the VALUES area by right-clicking a value in the VALUES area to open the shortcut menu, and then clicking Field Settings to open the Value Field Settings dialog box.
How to Edit PIVOT Values
- After the PIVOT Table is formed, click on one of the Values, then select "Value Field Settings".
- After that, please select the type of value based on your needs.
About Pivot tables
Pivot Tables are summaries of data packaged in interactive tables to enable you to create reports and analyze them by looking at comparisons, patterns and trends in the data you have.
Pivot Tables themselves are basically designed to:
• Display large amounts of query data in a variety of user-friendly ways.
• Perform sub totals and aggaggregateregate numerical data, summarize data by category and subcategory, and create customized calculations and formulas.
• Move row to column or column to row to see different summaries of the data source.
• Filtering, sorting, grouping and conditionally formatting the most useful and interesting data subsets helps you to focus only on the information you want.
• Present concise and attractive reports
• Helps focus results and drill down into details from summary data for the area you're looking for.
• Create data visualizations with pivot charts.
Learn more about pivot tables at https://brainly.com/question/28276853.
#SPJ4
