Show rank of defined value, in text object

[#1]

Hi everyone,

I would like to display the rank of a company according to sum(Amounts) within a text object. Does anyone know what the expression within the text object would look like?

I thought it might be something like:

=Rank({<[Company]={'ABC'}>}Sum(Amounts))

But that returned an error. Help please!

[jyothish8807]

Hi Andrew,

Try something like this:

Rank(Aggr(Sum(Amount),Company))

When you select any company it will display the rank.

Regards

KC

[#3]

Jyothish,

Thank you for your response. However, I am trying to display the rank of one particular company at all times, that would update based on other selections. I.e., rank of company A.

[jyothish8807]

Hi,

Try this:

=Rank(sum({<[Company]={'ABC'}>}Amounts))

Regards

KC

[sunny_talwar]

This is a kind of work around, but it seems to work. Hopefully you will find this useful.

Try this:

=Concat({State2}Aggr(Rank(Sum({<Company= >}Amount)), Company), '|')

Where State2 would be your name for the alternate state you need in your application. and you will need to lock down the selection of your Company in the alternate state's list box.

Hope this helps

Best,

S

[#6]

The problem with this method is that it always returns '1' for Company A, regardless of selection

[#7]

Is there no easier way to do this in a text object than use alternate states? I basically want to instruct it,

"Show Value for 'Company A' in Aggr(Rank(Sum(Amounts)))"

[sunny_talwar]

I am sure there must be an easier way to do it, but unfortunately I am not aware of it. I guess somebody else may chip in and give you a better answer. Sorry for not being very helpful.

Best,

S

[#9]

Thank you sunindia, your answer was helpful - I think it will work, but I will try to find a solution that does not involve alternate states first.

[sunny_talwar]

Sure thing Andrew.

Hope you succeed in your quest.

Best,

S