3 Replies Latest reply: Nov 27, 2014 2:08 PM by Jonathan Poole RSS

    Expressions using values of different rows from same datatable

      Hi all

       

      my datatable looks like this

       

      SKUPrimarySKUAvailabilityVolume
      AA530
      BA720
      CA9100
      DD310
      EE15

       

      I am trying to create a pivot chart showing

       

      SKUAvailabilityVolumePrimarySKUAvail. PrimarySKUVolumeOccupiedExp VolOccupied
      A

      5

      30A530*530*5
      B720A520*720*5
      C9100A5100*9100*5
      D310D310*310*3
      E15E15*15*1

       

      Basically the SKU field is leading and for some of these, there is a common primary SKU

      I would like to have some expressions that are calculations of fields directly related to SKU field (like VolumeOccupied, easy)
      I also would like to calculate based on values linked to PrimarySKU field, like Avail. PrimarySKU. This is more difficult for me.

      Or even a mixture of the two, so values linked to SKU together with values linked to PrimarySKUm as in Exp VolOccupied.

      Any idea how to realise last two expressions?

       

      thank you!