AnsweredAssumed Answered

Summary data in a portal

Question asked by tmslayton on Apr 23, 2015
Latest reply on Jun 11, 2015 by MicheleOlson



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:


Vehicle                      Cost

-----------------     -------------

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.