- Tables
- Pivot Tables
- Group Pivot Table Items
- Multi-level Pivot Table
- Frequency Distribution
- Pivot Chart
- Slicers
- Update Pivot Table
- Calculated Field/Item
DATA ANALYSIS - PIVOT FILTERS
When working with pivot tables, it might be useful to insert a calculated field or calculated item to the pivot table.
This session looks at how to add calculated fields and items to pivot tables.
After completing this session, you will be able to add, modify and delete calculated fields and calculated items.
Learning objectives
Insert a calculated field into a pivot table
Add a calculated item to a pivot table
Delete calculated fields and items from a pivot table
This session looks at how to add calculated fields and items to pivot tables.
After completing this session, you will be able to add, modify and delete calculated fields and calculated items.
Learning objectives
Insert a calculated field into a pivot table
Add a calculated item to a pivot table
Delete calculated fields and items from a pivot table
- Course provided by : Skills Hub
- Social Media :
