4 Replies Latest reply: Feb 20, 2013 10:17 AM by Alexander Voss RSS

    expression: get value from row where x=y

    Alexander Voss

      hi there,

       

      i need to peek some data within one table and don't know how to continue. Explains best on an example:

      ProductProductGroupUnitsUnitsGroup
      GroupAGroupA3030
      AGroupA1030
      BGroupA1030
      CGroupA1030
      GroupDGroupD4040
      DGroupD2040
      EGroupD2040

       

      ok, so in one column(UnitsGroup) I want to see the Values for a Group and my approach is looking for values where Product=ProductGroup

      I start with =if(Product=ProductGroup,sum(Units),)

      and now I am stucked with the ELSE

       

      any ideas?

       

      thanks in advance and best regards