Removing Duplication?

[navaneeth79]

Hi everyone,

I successfully removed duplication using group by but when I add date field I am getting duplication, how to remove the duplications in this case?

thanks in advance.

[Kushal_Chawda]

That depends on the data, which Date you need to pick, id there any other field to identify that? As your doing sum and Max, so there could not be any issue if you have same Date as well