I am creating a dashboard and would like to display the top n records grouped in a portal. In SQL I can do this in about 10 minutes. I am wondering how to approach this in FileMaker.
I have two tables:
Vehicles > Services. Services contains the repair and maintenance records for each vehicle. I would like to summarize the repair information by vehicle and order by total repair cost in descending order and limit the results to the five most costly vehicles. Basically I want it to look like this:
2008 Camry 1,000.00
2005 F-150 950.00
2012 Sentra 545.55
2015 Camaro 344.34
2014 Tacoma 122.44
I know there must be a way to do this.