Only show Tope 10 Expenses in chart
We are using FM 12 Advanced.
I am not sure how to tackle this task.
A Client has 20 expenses items, each item is a record. I want to show a graph of the 10 highest expense items. How do I set the rank or sort by expense amount and only show the top 10?
Clients are in a table with expenses being in a related table. Current relationship is Client:::ClientID_kp to Expenses::ClientID_kf.