Avatar

Employee

Hi Parvesh,

 

Thank you so much for paving the path,

 

Sorry for the misunderstanding actually now I don't have to calculate the total amount(amount*quantity). The amount column has the total amount data. Now I have to sum the amount of all purchases by a particular customer and put group by on the customerId and if the customer purchase amount is greater than 5000 then he will receive a mail. Let me share with you the CSV file containing the data, It may clear the scenario.

 

Mrityunjay_0-1654856628757.png

 

So basically we have to sum the rows(TotalAmount) and group by CustomerId. Can you please help me with it?  Please let me know in case any further clarification is needed.