How to Show Percentage of Parent Total in an Excel PivotTable

Excel allows you to quickly show the percentage using parent total in an Excel PivotTable. Once you create the Excel PivotTable, you can easily discover which type of report management you need. PivotTable gives the ability to easily manipulate the well organised information. The Value Filed Settings allows you to quickly perform different kind of summarizations as per your need. Calculated Fields. Calculated fields allows you to build the formulas which is based on the PivotTable value. You can easily convert your data and show values in-terms of percentage of parent total in an Excel PivotTable.

Must Read: How to Get Classic PivotTable Layout in Excel

Excel allows you to quickly insert additional data fields that you have already used. To show the percentage just like % of Parent Total you have to use PivotTable in active worksheet.

How to Show Percentage of Parent Total in an Excel PivotTable

Excel allows you to easily modify the format and pattern of existing PivotTable in active worksheet. If you want to show the percentage then you have to take following steps. The resulted value based on the parent total.

For eg: If you have a large worksheet employee database in which you want to show the percentage of total employees salary which is based on State wise. To do this job you have to take given simple steps.

Excel PivotTable

Step 1: Create or open an existing PivotTable and arrange the fields as per your need. Click anywhere in active PivotTable which shows the PivotTable fields pane in right side.

Must Read: Slicers in Excel used to Filter PivotTable Data

Step 2: In the Values area, select the Value Field Settings option from the field’s name drop down arrow. In the Value Field Settings box, click on Show Values As tab. Here you can check by default “No Calculation” is active in Show Values As box. Now, click on the drop down arrow and choose % of Parent Total option and click on the OK button.

The resulted values converted in percentage after selecting the % of parent total option. After using all these steps you can quickly analysis state wise amount percentage or performance. You can easily check which state emp earn how much percentage of his total salary.

I hope this this guide let’s you how to How to show the percentage of parent total in an Excel PivotTable. If you have any suggestion regarding this guide then please write us your suggestion in the comment box.

Leave a Reply

Your email address will not be published. Required fields are marked *