I have 10 Fields .
ReferenceNo| username|accountno|profitaccount|balanceaccount| MMC|KPL|LDDR|Amount|MSC
Now I need the sum of Amount as new field name 'Actual Amount' based on the condition if MMC= 'OK' and LDDR = 'OK' and only grouped by accountno|profitaccount|balanceaccount|..a
In the final output i need all the 10 fields plus the new field 'Actual Amount'
Thanks