3 Replies Latest reply: Apr 27, 2015 8:30 AM by Gysbert Wassenaar RSS

    Sum using distinct

    KENNETH ANDERSEN

      Hi,

       

      This is a snip of my data:

      Udklip.JPG

       

      I need to sum "Crop" and in this example my choice is 'Cereal'. I need to look at the ID and Spieces as well.

       

      ID 1 has one field with the size 10 (Cereal + Spring Barley) and one field with the size 12 (Cereal + Winter barley). This total field size is then 22 for Cereal.

       

      ID 2 has one field with the size 10 (Cereal + Winter wheat) and one field with the size 15 (Cereal + Oat) and one field with the size 20 (Cereal + oat) and finally one field with the size 20 (Cereal + Winter wheat). his total field size is then 67 for Cereal.

       

      All in all it's 87 for Cereal.

       

      How does the syntax for a new measure looks ?

       

      Cheers,

      Kenneth