12 Replies Latest reply: Feb 18, 2014 9:18 AM by BELEN VERA GARCIA RSS

    AGREGATION

    BELEN VERA GARCIA

        Good morning, please, i need some help on this.

       

      How can i get,  with a table of this kind of data:

          

       

      MARKETSTATE_NAMESum
      spainAndalucia1
      spainMadrid3
      spainValencia5
      spainGalicia7
      portugalPorto2
      portugalLisboa1
      portugalSetubal2

       

       

      Obtein an objct table like this:

       

      STATE_NAMESum
      Andalucia1
      Madrid3
      Valencia5
      Galicia7
      portugal5

       

      Thanks a lot!

       

      Belén