I have create a graph which shows income based on year and month. So far the table has 15 records from 01/2015 to 3/2016.
In the graph I wand to show only most recent 5 records. Could anyone help me with this task?
If the graph is based on the found set in the base table, simply script a find to isolate the correct records. If it's from related records, you could set the relationship to be limited by start/end dates you set in global date fields.
Get the dates with an ExecuteSQL and apply RightValues(...; 5) on its result.
Retrieving data ...