I was about to create a sort of "income statement" (profit and loss) in qlik Sense. I tried the extension P&L Smart, but it is actually too limited for what I meant to do. A pivot table, instead, might suit better. However, before starting, I wanted to know whether it is possible to subtract two specific rows in a pivot table, and if yes, how.
I know it's possible to create a P6L Statement in View, but I don't find any material related to Sense.
e.g. I have
I want to create a new row, say, Gross Profit, that is "Operating revenues"-"Operating expenses".
if you already tried to work with extension: P&L Smart, in this extension you use only 2 diimension, you can use for your issue: the straighttable, please check this web-page: https://www.vizlib.com/table/#4whatsnew
or you give me an example screenshot and we will find another solution
Sure, sorry but I thought somebody already tried to replicate a profit and loss statement before
I actually need something like this. With, let's say, Net earnings being the difference between "Earnings before income and taxes" and "Gross profit" (that's not economiccaly right, but it's just an example to show what I needed to do).