Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
raadwiptec
Creator II
Creator II

Group By Specific

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

Labels (1)
0 Replies