find the lowest calculated value from a list of calculated values

[Tauseef Sheik]

Hi,

I have a crosstable which has 3 columns. Column A had Routes, Column B has Net Spend on the route and Column C has Total no. of tickets on the route. See attached image. AFter I make a selection on the cross table my listbox gets dyanmically updated and it shows the which airlines operate on the route. See image 2

Each airlines have their total spend and tickets. I want to find out in the selected route which airline has the minimum spend/tickets. I thought I could do it via data function and I have written a function which takes in the the input and gives me the lowest spend/tickets but I'm not able to implement this in spotfire.

Any help appreciated by data functions or some other method.