Difference of values in pivot table

[Holyfix]

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

 

[alansidman]

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.

 

[Holyfix]

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 ?

 

[alansidman]

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.