Need top past due totals from individual invoice data to populate dashboard

[Cindy75]

Have a large list of invoices with a lookup on the customer number to return a type. Data includes standard invoice info (hidden in image), and past due and aging buckets. I need to know the 5 customers with the largest past due balance based on type chosen from a dropdown menu. Then I need totals for all past due and each bucket to populate on a dashboard. I'm hoping the attachment helps illustrate data. Sure appreciate help.

 

[kvsrinivasamurthy]

Pl upload data in XL2BB format with expected result.

 

[Peter_SSs]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Return largest 5 totals of listed items based on lookup criteria
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.