Bottom N based on added table column

[peter_chiu]

Hello:

In my iView, I have a table that uses an expression box that calculates the distance based on the locations from this table and, from a location stored on a separate form. I can calculate the distances correctly, but I would like to display only the 10 closest locations. The locations that are generated in the table are coming from a BI query.

I don't believe I can use the "LOWER" operator, because this is placed between the BI query and the output table since the query itself does not contain the distance data. Is there a way to do this? Any help would be appreciated. Thanks.

[Former Member]

For simple performance's sake, never do any aggregation, bottom/top N etc. on the VC side. Build your BI query correspondingly (there is a top/bottom N functionality).