Basic

[#1]

i have customer vs invoice(s) data sheet in excel

first I have to count no of invoices for each customer and

i I want to see customer who have max invoice in text object

[MarcoWedel]

please post sample data with expected result

[jagan]

Hi,

Try like this

=FirstSortedValue(customer, -Aggr(Count(Invoices), customer))

Regards,

Jagan.

[sundarakumar]

=max(aggr(count(invoice),customer))

This will do the trick..

Sundar

[MK_QSL · Accepted solution]

Number of Invoices for each customer

COUNT(DISTINCT [Invoice NO])

Customer having Maximum Invoices in Text Box...

=FirstSortedValue(Customer, -Aggr(Count(DISTINCT [Invoice NO]),Customer))

[#6]

thanks to all who helped me its solved

[sundarakumar]

Please close the thread by marking appropriate correct and helpful answers.

-Sundar