Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be this
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
like this
I use expression "sum({<Type={Revenue}>}Value) - sum({<Type={Expense}>}Value)"