AnsweredAssumed Answered

Only show Tope 10 Expenses in chart

Question asked by jwshelton22 on May 7, 2014
Latest reply on May 7, 2014 by jwshelton22


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.