4 Replies Latest reply: Oct 21, 2012 11:17 PM by Janzen Jino Balasbas RSS

    How to get the figures from different rows in which they are having the same ID ?

      Hi all,

       

      I have some data and it is illustrated as tables below.

      I would like to get the Amount for Category ‘R’ (250) and the SqFt (143) which having the same ID with the ID of Category ‘R’.

      ID

      Category

      Amount

      SqFt

      001

      E

      0

      0

      001

      F

      0

      143

      001

      R

      250

      0

      001

      W

      0

      0

       

      The final result I would like to get is like this:

      ID

      Category

      Amount

      SqFt

      001

      R

      250

      143

       

      Currently I can get the Amount for Category ‘R’ by using expression

      =sum(if(Category='R', Amount))

       

      But I have no idea to get the SqFt, which is 143.

       

      Thanks in advance for your great helps.