4 Replies Latest reply: Mar 1, 2016 4:05 AM by Andrew Mein RSS

    How to get sum of three rows and put it in one row in table in qliksense?

    ravikumar Mittapalli

      There is set of data that loaded into the data loader as shown  below

       

       

      order npo.revenue elementrevenueHeader 4
      Ord1material240
      ord1labour100
      ord1others30
      ord2material300
      ord2labour250
      ord2others120

       

       

       

       

      .Now i want to show this in table chart...so for each order i want the total revenue...that is sum of all the material labour and others revenue...its not accepting the sum function...is there any function that i can use to get the required output..

      please do let me know how to proceed.