Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
Maybe
FirstSortedValue( Name, -aggr(Value, Agent,Comtype,POS,OD,Value,Name),2)
Your firstsortedvalue is looking wrong... use as below
FirstSortedValue(Name, -aggr(max(Value),Agent,Comtype,POS,OD,Name),2)
If you want to stick with FirstSortedValue(), maybe like this:
=FirstSortedValue( Name, -aggr(sum(Value),Agent,Comtype,POS,OD,Name),2)
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?
Best,
Sunny
Thank You all ............Still getting error not getting desired output.
Maybe
FirstSortedValue( Name, -aggr(Value, Agent,Comtype,POS,OD,Value,Name),2)
Awesome
Excellent Bro ..........Thank You.
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