Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
grajmca_sgp123
Creator
Creator

how to do subtraction in pivot table of Profit and loss statement

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

Labels (1)
0 Replies