Refer to step by step instance displays tips on how to calculate the proportion excess between two columns in a pivot desk in Excel.
Step 1: Input the Information
First, let’s input please see gross sales information for 3 other retail outlets:
Step 2: Form the Pivot Desk
Nearest, let’s manufacture please see pivot desk to summarize the full gross sales by means of bind and by means of generation:
Step 3: Calculate Share Excess Between Two Columns within the Pivot Desk
Think we want to manufacture a unutilized column within the pivot desk that presentations the proportion excess between the Sum of 2021 and Sum of 2022 columns.
To take action, we want to upload a calculated grassland to the pivot desk by means of clicking on any worth within the pivot desk, next clicking the PivotTable Analyze tab, next clicking Farmlands, Pieces & Units, next Calculated Garden:
Within the unutilized window that looks, kind “Percentage Difference” within the Identify grassland, next kind please see within the Formulation grassland:
= ('2022' - '2021') / '2021'
After click on Upload, next click on OK.
This calculated grassland will routinely be added to the pivot desk:
This unutilized grassland presentations the proportion excess between the 2022 and 2021 gross sales for every bind.
For instance:
- There was once a 16.67% build up in gross sales between 2021 and 2022 for bind A.
- There was once a 15.44% build up in gross sales between 2021 and 2022 for bind B.
- There was once a 24.62% build up in gross sales between 2021 and 2022 for bind C.
Really feel isolated to focus on the values within the unutilized grassland and alter their structure to a share structure:
Supplementary Assets
Refer to tutorials give an explanation for tips on how to carry out alternative ordinary duties in Excel:
Easy methods to Sum Two Columns in a Pivot Desk in Excel
Easy methods to Subtract Two Columns in a Pivot Desk in Excel
Easy methods to Calculate Weighted Moderate in a Pivot Desk in Excel
