2 Replies Latest reply on Jul 10, 2018 3:54 AM by meenu choudhary

    distinct sum of value using LOD function

    VINAY NARANDRALAL

      Dear all,

         

      I ahve data like below...

       

      Calendar_DateDepot_NumberPartGroup_CodeSale_Qty
      08/07/201838055014318H15CC70
      08/07/201838055260166H15CC28
      08/07/201892055260498H15CC38
      08/07/201838055260498H15CC38
      08/07/201852076638627H15CC0
      08/07/201852076638644H15CC0
      08/07/201838082996366H15CC31
      09/07/201838055014318H15CC50
      09/07/201838055260166H15CC20
      09/07/201892055260498H15CC25
      09/07/201838055260498H15CC25
      09/07/201852076638627H15CC60
      09/07/201852076638644H15CC45
      09/07/201838082996366H15CC45

       

      and I want something like

       

        

      Calendar_DateGroup_CodeSale_Qty
      08/07/2018H15CC167
      09/07/2018H15CC245

       

      In short if you see in data red highlighted
      row repeated by depot_number which should sum only once when aggregate by Group_code

      I have tried using LOD function below but not working

      Sum({ FIXED [Depot_Number]: AVG(Sale_Qty)})

      Please can you help me?

      Thanks & Regards

      Vinay