How to subtract two rows within the same measure from each other and get the difference in a new row underneath (I am replicating a pivot table).

Hi @Esther Aller​ !

you are correct that I am not just subtracting two rows (I will be dividing the result as well for variance).

Currently i'm tinkering with using a calculated field: (LOOKUP(SUM([CallsOffered_3YR]), 1)-LOOKUP(SUM([CallsOffered_3YR]), 0))/(LOOKUP(SUM([CallsOffered_3YR]), 0)) and then setting the measure to 'Table (down)' in the marks. This hasn't exactly given me what I needed but it's close? If there's better way let me know!

Given how the data is, a calculation for each row wasn't the best method (I tried that first).