Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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))
please post sample data with expected result
Hi,
Try like this
=FirstSortedValue(customer, -Aggr(Count(Invoices), customer))
Regards,
Jagan.
=max(aggr(count(invoice),customer))
This will do the trick..
Sundar
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))
thanks to all who helped me its solved
Please close the thread by marking appropriate correct and helpful answers.
-Sundar