3 Replies Latest reply: Jan 5, 2012 8:26 AM by Some Nath Roy RSS

    Extract Excluded set

    Some Nath Roy

      Dear All,

       

      Consider the table below:

       

       

      PlantConumer      Qty
      XA10
      XB12
      XC14
      YD10
      YA11
      ZC18
      ZE20

       

      I want to create a Straight table which will show the list of cunsumer [along with sum(Qty)] that are not linked with the selected Plant.

      For example, if any user select 'X' from Plant list, the resulted table should be as below:

       

       

      PlantConumersum(Qty)
      YD10
      ZE20

       

      Pls. note that this needs to be done in expression level not in script level.

      Any help would be highly appreceated.

       

      Thanks & Regards,

      Somnath