Good morning, I need to know if it's possible to put inside a PIVOT an additional column containing the difference between the amounts of two other columns.
Basically I need to insert a third column that calculates the difference between the first two scenarios, but in my excel are contained in the same column (as it's possible to see in the following image) and thus I can't use the formula Sum (X) - Sum (Y).
Thanks in advance for the attention