5 Replies Latest reply: May 24, 2010 6:34 AM by jbeleza RSS

    Problem with aggregate/set analysis

      Hi,

      I'm trying to find a way to create a table where I can only see the customers with the same adress code and with demand=0.

      So, I have a table like this one:

       

      codecustomerdemand
      IN008910
      IN008950
      IN008981
      IN009292
      IN0093105
      IN0095113
      IN0095137


       

      And want to get one like this, for all customers with repeated adress code and demand=0:

       

      codecustomerdemand
      IN008910
      IN008950


      How can I do it? Should i use a pivot table? (I just can't manage it to work correctly...)