Group By Specific

[raadwiptec]

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