1 Reply Latest reply on Feb 14, 2018 12:22 AM by Norbert Maijoor

    Fixed sum based on distinct IDs

    Ahmed Mukhtar

      I have 2 columns, items (Items_ID) and the sale price


      I want the count of unique ID (have duplications) so I simply did countD(Items_id)


      I cant do the same. I need for each UNIQUE Items_ID, sum of the sales price


      How can I do unique sum?


      I tried


      {Fixed countd(Items_ID): sum(Saleprice)}


      but it gives cant mix aggregate and non aggregate error.


      What can i do?


      any help please??