Customer with Highest Total Sales

[avastani]

Hi,

Silly question. I used to be able to do this on the fly but stuck now.

I have the total Sales Amount for the customer group in my application, but would now like to report who that Customer Group is. How would I be able to do that?

Highest Total Sales by Customer Group is below:

Max(AGGR(SUM({<[Brand] = {X},[Fiscal Year] = {$(=Max([Fiscal Year]))},Source={Actual}>} [Sales]), [Customer Group]))

[Anonymous]

Try FirstSortedValue() fiunction, maybe this:

FirstSortedValue([Customer Group], -SUM({<[Brand] = {X},[Fiscal Year] = {$(=Max([Fiscal Year]))},Source={Actual}>} [Sales]))

"Minus" to sort in descending order.

Regards,

Michael