2 Replies Latest reply: Dec 20, 2017 12:01 PM by Andrea Gigliotti RSS

    Sum rows with the same name

    josh goh

      Hi all,

       

      I need some help with the following problem in Qliksense.

       

      I'm loading an excel with the following data:

      Name | Expense

      A        | $35

      B        | $10

      A        | $20

      B        | $25

      C        | $15


      And I would like to put it into a table that consolidates all the unique Names:

      ie.

      Name | Expense

      A        | $55

      B        | $35

      C        | $15


      How do I perform this in Qliksense?

       

      Thanks!