Add Subtotals in Pivot Table. To show percentage of total in an Excel Pivot Table, create your PivotTable with the information you want summarized, and then follow the steps below. The value as a percentage for successive items in the chosen Base field that are displayed as a running total. Once you have received the verification code, you will be able to choose a new password for your account. To show the percent of a subtotal, use the following options (Excel 2010 and later): See screenshot: How to sort by sum in Pivot Table in Excel? Please follow below steps to create a pivot table with the percentage of a grand total column or subtotal column in Excel. For example, in the Central region, there were 12 desks sold and 103 Binders sold. In the resulting pivot table worksheet, expand Table1 in the PivotTable Fields Menu on the right. 1. The region subtotal rows would show the percentage of their parent total, which is the report total. Manipulating the data in this … At this point a new worksheet will appear within your workbook. My pivot table is as follows: Page field: Institution (text) Row fields: Loan Type (text) and Original Term (number) Data fields: Sum of Account Balance and Count of Accounts I would like to show a field that returns the Sum of Account Balance as a % of the Subtotal. This pivot table shows coffee product sales by month for the imaginary business […] Select the source data, and click Insert > PivotTable. Depending on your requirements, you may find the need to show Subtotals in Pivot Table. Pivot Table Percentage Of Subtotal Excel 2010. masuzi December 17, 2018 Uncategorized No Comments. This feature was introduced in Excel 2010, so applies only to 2010 and later versions. To quickly display or hide the current subtotal, right-click the item of the field, and then select or clear the check box next to Subtotal "