Adding customer dimension row

[didierodayo]

Hello,

I am trying to add a new Dimension row to this pivot table that will give me the Surplus/Deficit (Revenue- Expense). What would a neat way of doing this be?

LOAD * INLINE [
Type, Code, Value
Revenue, UK, 50000
Revenue, UK, 25000
Expense, UK, 35000
Expense, UK, 54000
Expense, US, 40000
Revenue, US, 20000
Revenue, US, 60000
];

thanks

[aarkay29]

May be this

[didierodayo]

I don't want to change the table structure. I just want to add a new row below Expense (Surplus/Deficit) which displays the value of Revenue - Expense.

thanks

[inoruoya]

like this

I use expression "sum({<Type={Revenue}>}Value) - sum({<Type={Expense}>}Value)"