FAQ:Is there a possibility to limit the number of elements displayed in a list query?
It is possible to limit the elements displayed in a list query to a certain number.
In the following example, we would like to display the 15 customers with the highest sales, i.e. those with the highest value in FR1:
The list query can be structured as follows:
SetDat(1;1;10001;4762;344203;select top 15 (F000) from prename_Z000 where zid>10000 order by F000 desc)
Please note that Professional Planner only displays the annual value in this formula.