Difference of values in pivot table

H

Holyfix

New Member
Joined
Oct 14, 2021
Messages
11
Office Version
  1. 365
  2. 2019
  3. 2016
Platform
  1. Windows
Hello everyone,

I would like to kindly ask you for help.

I have data loaded in power query, which is then loaded to pivot table. In the pivot table there are two columns with values.

I need to find any difference in the values (preferably by sorting out zero difference). Is there a way to add a column after CW22 which would be the difference between CW21 and CW22 ?

I have tried to show values as difference but the formatting is not very suitable, so I am wondering if there is any other way.

Thank you very much
 

Attachments

  • pivot.jpg
    pivot.jpg
    31.5 KB · Views: 2
  • pivot setup.jpg
    pivot setup.jpg
    23.2 KB · Views: 2

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.
Sort by date Sort by votes
When you close and load your data to a pivot table, instead close and load to the Data Model. Once in the data model, open the data in Power Pivot and create a measure to calculate the difference between the two fields.
 
Upvote 0
First of all thank you. This is what i've got. Is this what you were talking about ? Is there a way to filter these values in the pivot table ?
 

Attachments

  • Pivot results.jpg
    Pivot results.jpg
    35.3 KB · Views: 1
Upvote 0
Difficult to analyze and offer up a solution from a picture. It would make more sense if you offered up your sample data using XL2BB. Offer up your source data from PQ and your proposed PT from Power Pivot. I believe your data needs to tweaked in PQ to put each item on the same line.
 
Upvote 0
You must log in or register to reply here.

Similar threads

Z
  • Question
Show values as difference from months & years (pivot table)
Replies
0
Views
29
zico8
Z
M
  • Question
Pivot Table Help
Replies
1
Views
161
shift-del
shift-del
trishcollins
  • Question
Private Worksheet Pivot table Update is affecting Pivot table on another worksheet which uses same data source
Replies
0
Views
27
trishcollins
trishcollins
M
  • Question
Getting Power Query data to an Excel worksheet
Replies
4
Views
375
MichaelMorris
M
M
  • Question
Excel pivot table query - retaining filters on pivot in absence of data
2
Replies
10
Views
1K
Alex Blakenburg
A

Forum statistics

Threads
1,216,500
Messages
6,131,015
Members
449,615
Latest member
Nic0la

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top