3 Replies Latest reply: Jul 4, 2018 5:04 PM by Petter Skjolden RSS

    Adding manual rows in a P&L table in Qlik Sense

    Juan Julian Herranz Sarrion

      Hi everyone,

       

      This is my first post in the community and I am sure it won't be last. I was wondering if any of you knew how to add rows within a dimension in order to create a P&L. So far I can pull the data in the following format:

       

      Categorised (CTD)
      Revenue
      CoS - Circuits
      CoS - Other
      CoS - Resources
      Direct Opex
      Opex Resources
      Overheads
      LRAIC Opex
      Depreciation
      Capex
      LRAIC Capex
      Net Working Capital

      Cost excl OH

       

      However, I need it to end up looking like this?

         

      Revenue
      CoS - Circuits
      CoS - Resources
      CoS - Other
      Cost of Sale (Sum of CoS)
      Gross Margin  (Revenue - Cost of sale)
      GM%
      Direct Opex
      Opex Resources
      LRAIC Opex
      Total Opex
      Overheads
      EBITDA (Gross Margin + Total Opex + Overheads)
      EBITDA %
      Depreciation
      LRAIC Capex
      EBIT (EBITDA + Depreciation + LRAIC Capex)
      EBIT %

       

      Is there any way I can manually code that in the backend/front end to make sure the dimension contains the right information.

       

      Thank you very much.