cancel
Showing results for 
Search instead for 
Did you mean: 

How can sorted dataset in Xcelsius

Former Member
0 Kudos

Hi Experts,

My requirement is to get dataset in ascending order. Need a dynamic way to find it out at run time.

Help will be appreciated and suitable points will be awarded.

Accepted Solutions (1)

Accepted Solutions (1)

DebjitSingha
Active Contributor
0 Kudos

Hi,

sorting can be done at run time with the help of the standard component property available. After preview just click on the header to get it sorted.

Good Luck.

Former Member
0 Kudos

Is there a way by which we can find the top or bottom entries. We need to show them on pie chart.

DebjitSingha
Active Contributor
0 Kudos

Try to use Excel function like MAX , LARGE or RANK. Any one of them will work( like with MAX we need to use INDEX and MATCH function to do the job)

Hope this might be of some help.

Former Member
0 Kudos

I will try this. Is there any way that I can get a scenario based example a bit in detail.

DebjitSingha
Active Contributor
0 Kudos

There are many articles on this. There are quite a few ways to achieve this requirement.

Below link gives a scenario based explanation to find top 5 entries (dynamically). You can do the tricking according to your requirements.

[http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/60bba2a2-9053-2e10-fb90-dd71175e0fda]

Hope this is what you might be looking for.

Good Luck

Former Member
0 Kudos

Thanks Debjit for your quick response. Even though this is not exactly what we are looking for but it gives us another choice to achieve out target

DebjitSingha
Active Contributor
0 Kudos

As I said there are many ways to sort data in xcelsius. Below link might be helpful in some situation.

[http://www.youtube.com/watch?v=7oxHGMEV300]

Former Member
0 Kudos

Thanks.

Answers (0)