Rank Function need desired output

[#1]

Hi

Help me out in getting desired output.  I am trying to get ranking to aggregated data. One expression is giving wrong output please find the yellow marked column in  output and expected output.

Aggr(Sum([Value]), Agent,Comtype,POS,OD)

Aggr(FirstSortedValue(Name, -aggr(max(Value),Agent,Comtype,POS,OD,Name)), Agent,Comtype,POS,OD)

aggr(max(Value),Agent,Comtype,POS,OD)

Aggr(FirstSortedValue(Name, -aggr(max(Value,2),Agent,Comtype,POS,OD)), Agent,Comtype,POS,OD) (this is the expression

giving wrong output.

aggr(max(Value,2),Agent,Comtype,POS,OD)

Aggr(FirstSortedValue(Name, -aggr(max(Value,3),Agent,Comtype,POS,OD)), Agent,Comtype,POS,OD)

aggr(max(Value,3),Agent,Comtype,POS,OD)

[MK_QSL]

Your firstsortedvalue is looking wrong... use as below

FirstSortedValue(Name, -aggr(max(Value),Agent,Comtype,POS,OD,Name),2)

[swuehl]

If you want to stick with FirstSortedValue(), maybe like this:

=FirstSortedValue( Name, -aggr(sum(Value),Agent,Comtype,POS,OD,Name),2)

[sunny_talwar]

Hey Manish, I tried doing this, but it doesn't give correct output for two rows:

Is there a way to handle this with FirstSortedValue() still?

swuehl‌

Best,

Sunny

[#5]

Thank You all ............Still getting error not getting desired output.

[swuehl · Accepted solution]

Maybe

FirstSortedValue( Name, -aggr(Value, Agent,Comtype,POS,OD,Value,Name),2)

[sunny_talwar]

Awesome

[#8]

Excellent Bro ..........Thank You.

[veidlburkhard]

Hi shyamkb18,

sorry to say that, but for me it looks like your data is kind of contradictory:

e.g. for Agent B Business Class BLR with DEL-JP the name F1 has value 50 and 200 in week 1!?!

If you do the changes like this:

Your original expression is working fine.

Regards

Burkhard