Does SAC have a Rank function?

[MadhuLodugu48]

I did not find the Rank function in the calculation editor when creating a column that simply ranks values in a measure column like below. Please let me know if there is a way to do this in a story in SAC.

Sales             Rank

200                   4

350                   3

500                   2

800                   1

[Yogeshwar_M]

Hi @MadhuLodugu48 ,

Here are the steps to create rank in story this is not standard method however you can use this way as your requirement is to give rank randomly as per your choice.

1. You need to be create 2 Dummy Rank measure in model level as shown below 

1. Create story top of that to use this rank measure

1. Enter value in Rank as per your requirement, for ex. 

1. Here Total of both rank measures as per your requirement.

Just using control key click on both Rank measure right click on and add client calculation

As shown below

1. Final Output

Kindly upvote/accept as solution if you find it helpful.

Thanks.

[Yogeshwar_M]

Hi @MadhuLodugu48 ,

You can do this just right click on measure section as shown below then

add client calculation as shown in below

After click on Rank Number on column will add to show rank

Kindly upvote and like if you find it useful.

Thanks

[MadhuLodugu48]

Hi Yogeshwar, Thank you but that is not all. I want to be able to create similar Rank columns for a couple of measures in the able and then be able to add the values in the Rank columns horizontally (row) and then arrive at a Final column which contains the sum of rank values in each cell. I could not achieve this with the method you specified above. I am curious to know if a calculated rank column can be created manually like other calculations so that my requirement can be achieved?

[Yogeshwar_M]

Hi MadhuLodugu,

You can achieve this by creating dummy measure in model Here below shows sample.

I have 2 measure Profit and Sale

Then I create 2 Rank column for Rank_Profit and Rank_Sale 

Then Sum of Rank

You can give rank as per your choice then addition of this rank measures in last column As shown below

Thanks.

[MadhuLodugu48]

Yogeshwar, I did not understand how the rank columns can be created in the model. could you please explain. There is no rank function at the model level to my knowledge.