I have a matrix broken shown as such: I would like to create a difference column that would look like this in excel pivot table:This is how the raw data looks like: Let me know if any part is not clear. Happy to explain further.

Anonymous i got itduplicate data source Table1 as 'Table 1 (2)'then create new table New Table = union('Table1';summarize('Table1 (2)';'Table1 (2)'[Vessel];'Table1 (2)'[Voyage];"Data Type";"zDifference";"Revenue";sumx('Table1 (2)';(calculate(SUM('Table1 (2)'[Revenue]);'Table1 (2)'[Data Type]="Actual")-calculate(SUM('Table1 (2)'[Revenue]);'Table1 (2)'[Data Type]="Estimate")));"Cost";sumx('Table1 (2)';(calculate(SUM('Table1 (2)'[Cost]);'Table1 (2)'[Data Type]="Actual")-calculate(SUM('Table1 (2)'[Cost]);'Table1 (2)'[Data Type]="Estimate"))))) aaandall fields are from New Table, of coursedo not hesitate to give a kudo to useful posts and mark solutions as solution

Difference between 2 sub columns in a matrix

Forum Discussion

Related content

1. How to add two different calculated columns of two different table

Different schema into different destination

How to add two different calculated columns of two different table

Different Groupby Column Names in Summarize

Need column level difference