Change % in Pivot Table
Excel Tips and Tricks

Change% in Pivot Table

In this article you will learn how to show Change% in a pivot table. For example, you have month wise sales and revenue in your pivot and you have to show the change% in sales and revenue in compare of previous month.

We will show the change% as given in below image.

Change% in Pivot Table
Change% in Pivot Table

Steps show the change% in a pivot table-

  • Lets say we have below given sales data.
Sales Data
Sales Data
  • Create a pivot table for above data.
  • Drag the Date in Rows.
  • Sales and Revenue in Values.
Create Pivot Table
Create Pivot Table
  • Right click on the Dates and click on Group.
  • Click on Months in Grouping window.

 

Grouping window
Grouping window
  • After grouping, drag the Sales and Revenue again in Values.

 

Drag Sales and Revenue Again
Drag Sales and Revenue Again
  • Right click on in the Sum of Sales2.
  • Go to the Show Value As >>%Difference From…
%Difference From
%Difference From
  • Select the Base Field as Date.
  • Select the Base Item as (previous).

 

Show Value as window
Show Value as window
  • Repeat the same activity for Sum of Revenue2 column.
  • Change the column name  Sum of Sales2 as Sales Change%.
  • Change the column name  Sum of Revenue2 as Revenue Change%.
  • Change the pivot style.

 

Pivot table with change%
Pivot table with change%

  • Repeat the same activity with the Revenue Change%.
  • Insert a Slicer for Location and change the Slicer style.

 

Click here to download the this excel workbook.

 

Watch the step by step tutorial:

 

PK
My Name is PK. I am founder of PK-AnExcelExpert.com. I am a Microsoft Certified Professional. I have more than 10 years of experience in Data Visualization, Excel Automation and dashboard creation. Excel is my passion and I like to do always something innovative in Excel and share it with other people.
https://www.pk-anexcelexpert.com

Leave a Reply

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