Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

ranking

hi

i am trying to create a bar chart showing the top 5 countries with highest inflation rate.

i have three list boxes with details of country,capital and inflation rate.

what expression must be used??

explain the syntax in detail??

1 Solution

Accepted Solutions
CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

     You can use this expression

=Sum({<Country={"=Rank(Sum(InflationRate))<6"}>} InflationRate)

Celambarasan

View solution in original post

5 Replies
Anonymous
Not applicable
Author

Hi

     the attached file will be use for your requirement

Regards

Ashok

Anonymous
Not applicable
Author

Hi

          Here i attached the same file with bar chart

Regards

Ashok

CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

     You can use this expression

=Sum({<Country={"=Rank(Sum(InflationRate))<6"}>} InflationRate)

Celambarasan

Not applicable
Author

is there any book or something like that from where i can learn the syntax of writing the expressions??

CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

     For set analysis you can use the attached material it will be usefull.

Celambarasan