Difference Column in Matrix

[CJANE]

I feel like I am trying to accomplish something very easy but cant find the correct solution.  I have a matrix with sales listed for Trust A, B, and C.  I have two rows listing sales for 2016 and 2017.  I simply want a column displaying the difference between 2016 and 2017 sales.  Any suggetions on a solution that doesnt require multiple new columns or methods.  Thanks in advanced for any help.

	2016 Sales	2017 Sales	Difference
Trust A	5,000,000	24,120,000	-19,120,000
Trust B	6000	5,000,000	-4,994,000
Trust C	200	6000	-5,800
Trust D	24,120,000	200	24,119,800

[v-ljerr-msft]

Hi @CJANE,

According to your description above, I don't think it is possible to do it within a Matrix visual currently. You may need to find a way to show "2016 Sales" and "2017 Sales" as different columns in a Table visual, then you should be able to write a measure to calculate the difference between them easily and show the measure on the same Table visual with the "Trust" column.

Regards