Jump to content
We've recently updated our Privacy Statement, available here. ×

find the lowest calculated value from a list of calculated values


Tauseef Sheik

Recommended Posts

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.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...