Pivot Table is one of Excel’s most powerful features. So in this tutorial, I will be showing you how to create Multi-level Pivot Table in Excel
How to create a Multiple Row Field Pivot Tables in Excel?
To create a Multiple Row Field Pivot Table in Excel follow the steps given below:
1. Insert a Pivot Table by clicking on Insert Tab > Pivot Table
2. Drag the fields Division and Rating in the Row field area. Salary in the Value field area.
3. Lastly, your Multiple Row fields are inserted in the Pivot Table
How to create Multiple Value field Pivot Table in Excel?
To create Multiple Value field Pivot Table in Excel follow the steps given below:
1. Insert a Pivot Table by clicking on Insert Tab > Pivot Table
2. Drag the Fields. Division Field to the Row field Area. Twice drag the Salary field in the Value field area
3. Right click in the second salary column > Select value field setting
4. From the drop down menu of Show value as tab > Select % of grand total
5. Lastly your Multiple Value Fields are inserted in Excel
How to create Multiple Report Filter Field Pivot Table in Excel?
To create Multiple Report Filter Field Pivot Table in Excel follow the steps given below:
1. Insert a Pivot Table by clicking on Insert Tab > Pivot Table
2. Drag the fields Division and Rating in the Report Field Area. Date of Join in the Row Field Area and Salary in the Value Field Area
3. Group the Row Field area in Months
4. Filter your data by rating as 1 and Division as AD or any other of your choice
5. Lastly your Multiple Report Filter Field are inserted in Excel.