10 Replies Latest reply: Jul 4, 2017 9:56 AM by Gabriele Formici RSS

    Subtracting rows in pivot table

    Gabriele Formici

      Hi everyone,

      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

      Operating revenues

      Operating expenses.

      I want to create a new row, say, Gross Profit, that is "Operating revenues"-"Operating expenses".

      Thanks in advance.