Skip to main content
Announcements
Discover what’s possible with embedded analytics! March 6, 10 AM ET SIGN UP!
cancel
Showing results for 
Search instead for 
Did you mean: 
didierodayo
Partner - Creator III
Partner - Creator III

Adding customer dimension row

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

3 Replies
aarkay29
Specialist
Specialist

May be this

Sample.png

didierodayo
Partner - Creator III
Partner - Creator III
Author

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
Partner - Contributor III
Partner - Contributor III

like this

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