i have 2 rows
1 john smith 10 objects
2 john smith 10 objects
i need to group by last name but only show 10 in objects. this has to be done in aggregation or using SQl..
what i see is
john smith 20 objects
i wanna see
john smith 10 objects.
any ideas?>
i am on the latest SAP hana