how to display the first top 5 salaries in bar chart ?

[#1]

how to display the first top 5 salaries in bar chart ?

[#2]

you can achieve this by using dimension limit or rank function find the attachment to get an idea or share your sample application..

hope this help you

[vikasmahajan]

Hii

There are 2 ways you can achieve these results:

1. You can use Rank() function in the expressions.

2. You can use "Dimension limits" & set some smallest, largest or first values to be shown. to access Dimesion limits tab, you need to go to the properties of the chart & there you will a tab as "Dimension Limits" .

Hope this helps!

Vikas

[rustyfishbones]

you can try

if(rank(sum(Salary)) <=5,sum(Salary))

Regards

Alan

[#5]

right click on chart>dimension limits tab> select top 5

or

if(rank(sum(sales))<=5,sum(sales)

[satishkurra]

Hi

We can achieve this in 3 ways.

1. Use dimension limits tab in Chart Properties

a. Specify Show Only as Largest and specify value as 5 (If request put variable here and call from outside instead of hard coding)

b. Uncheck Others

2. Use Rank function

a. In char properties for Dimension Limits, specify calculated dimensions as

=if(Aggr(Rank(Sum(Sales)), Customer) <=2, Customer)

3. Use SET ANALYSIS

a. In chart properties, in expressions tab

sum({$<Category={"=Aggr(Rank(Sum(Investment),20),Investment)<=5"}>}Investment)

Approach 1 and 2 will hamper the performance. Please use Approach 3 for better performance.

Thanks

Satish

[amit_saini]

Harish,

Check this.

Thanks,

AS