8 Replies Latest reply: Oct 16, 2017 5:08 AM by Andrew Walker

# Top n data

1st table

 Airport Revenue in US\$ Flights Grand Total 57,732,036,757 1,068,164 Maya-Maya Airport 24,082,856,986 467,982 Asmara International Airport 16,156,464,665 280,323 Cairo International Airport 10,150,200,885 188,215 Tripoli International Airport 3,460,486,572 48,468 Cape Town International Airport 2,335,975,371 44,474 Calgary International Airport 772,424,866 14,234 Vancouver International Airport 505,395,812 11,452 Ontario International Airport 268,231,601 13,016

2nd table extracted from 1st table(Top 3 Airports)

 Airport Revenue in US\$ Flights Grand Total 50,389,522,535 936,520 Maya-Maya Airport 24,082,856,986 467,982 Asmara International Airport 16,156,464,665 280,323 Cairo International Airport 10,150,200,885 188,215

I am having problem in acquiring the result of 2nd table. Can anyone help me? I want to see any top n airports with revenue & flight detail as mentioned in the 2nd table.

• ###### Re: Top n data

hi

try this

dimesnison limits-> largest 3 value and dont show  others

will this work for you ?

regards

• ###### Re: Top n data

I do not want to use dim limits as I have already used variable vCounter which varies from 0 to 8 where 0 means all airports & remaining numbers for top n. I actually need to know the exact expression to be used for both revenue & flights in case of all or top n.

• ###### Re: Top n data

You can use the variable in place of that number something like =\$( vCounter) iin the expression. It will be the simplest solution for you.

• ###### Re: Top n data

I need to know the exact expression to be used for the issue.

• ###### Re: Top n data

can you share your sample app? Please try using =\$(variablename ) in the dimensionlimit tab to show the top n value.

• ###### Re: Top n data

Aggr(if(Rank(Sum(Revenue),1,1) <=3,Airport),Airport)

In a straight table check the Suppress When Value Is Null checkbox.

Regards

Andrew

• ###### Re: Top n data

The problem exists in expression tab not in dimension. I need to know exact expression to be used for top n.