Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
hi
try this
dimesnison limits-> largest 3 value and dont show others
will this work for you ?
regards
Pradosh
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.
You can use the variable in place of that number something like =$( vCounter) iin the expression. It will be the simplest solution for you.
I need to know the exact expression to be used for the issue.
can you share your sample app? Please try using =$(variablename ) in the dimensionlimit tab to show the top n value.
Hi Arshad,
Try this as your dimension:
Aggr(if(Rank(Sum(Revenue),1,1) <=3,Airport),Airport)
In a straight table check the Suppress When Value Is Null checkbox.
Regards
Andrew
The problem exists in expression tab not in dimension. I need to know exact expression to be used for top n.
Hi Arshad,
Have you tried the calculated dimension? It will give you the top 3 in a straight table.
Regards
Andrew