public List<AcctSumList> getAccountSummary60() {
list<AcctSumList> acctSummary = new List<AcctSumList>();
List<AggregateResult> getList = [SELECT Account.Name acctName, sum(amount) TotalAmount
FROM Opportunity
WHERE (Account.OwnerId =: UserId OR
Account.Client_Specialist_1__c =:UserId OR
Account.Client_Specialist_2__c =:UserId OR
Account.Client_Executive__c =:UserId)
AND StageName='B. Decision Due' AND CloseDate = THIS_Quarter
GROUP BY Account.Name ORDER BY sum(amount) DESC LIMIT 10];
for(AggregateResult agg : getList) {
String AccountName = (string)agg.get('acctName');
Double TotalAmount = (double)agg.get('TotalAmount');
acctSummary.add(new AcctSumList(AccountName, TotalAmount));
}
return acctSummary;
}
In your aggregate query see if you can include Id in the Group by Clause (GROUP BY Account.Name,Id).Any field you would need should be included either in group by clause or it should be aggrgated. See what logically makes sense to include Id in group by clause.something like...SELECT Id,Account.Name acctName, sum(amount) TotalAmount FROM Opportunity GROUP BY Account.Name,Id ORDER BY sum(amount) DESC LIMIT 10
