hi ,
I am trying to do profit and loss statement. I have done the row wise calculation using flags in pivot table, but I have a requirement where I have to subtract two rows .
for example : I want to add new value as "Other Risk" to 'Exec P&L Heading' column and the logic is below.
Other Risk = Revenue - (Net Interest Income + Net Fee Income + Net Trading Income)
please check the sample app and suggest some idea
