Subtract values from the same column according to the criteria of others

[l_lolo]

Hello, I need help because I have been trying to solve the following problem for a long time:
I have a table with 5 columns that are divided into the sales area, the product and a specific date (week of the year) the planned sale and the actual sale:

Area	Product	Scenario	year/month/week	unit
Congelados	Pizza	Ventas planificadas	A2021 M1 S2	200
Frescos	Yogures	Ventas planificadas	A2021 M1 S2	100
Verdura	Manzana	Ventas Planificadas	A2021 M1 S2	300
Congelados	Helado	ventas planificadas	A2021 M1 S2	200
Congelados	Pizza	ventas reales	A2021 M1 S2	200
Frescos	Yogures	ventas reales	A2021 M1 S2	50
Verdura	Manzana	ventas reales	A2021 M1 S2	150
Congelados	Helado	ventas reales	A2021 M1 S2	150

This table that I have created in PowerQuery is fed from an excel table that is updated weekly.

I have tried to create an additional column in the Pivot that is Delta between Planned and Actual. My problem is that I cannot find a way to subtract the actual value from the planned one, if the values of the area & product & year/month/week columns coincide. That is, it automatically calculates the difference between planned and actual for a certain product on a specific date.

I thought that the result should be the following:

Area	Product	scenario	year/month/week	unit	delta with actual
"	"	"	"	"	0
"	"	"	"	"	50
"	"	"	"	"	150
"	"	"	"	"	50
"	"	"	"	"
"	"	"	"	"
"	"	"	"	"
"	"	"	"	"

I attach the excel example.

Thank you all for the help

 

[sijpie]

Welcome to the board l_lolo. I'd like to help, but I don't see the column planned sales and actual sales in your examples. are they part of the pivot table?