How to sort based on 2 string values

[Anonymous]

Hi

I have 2 columns Group and Function , I need to sort Function based on Group values and retrieve the first Function value based on Group values

Group Values

Agent

Billing

Functions values

ABC

BBB

CCC

DDD

Association  between Group and Function is as below :

Agent - ABC

Agent - BBB

Billing - CCC

Billing - DDD

I need to get ABC value

Thanks!

[Anonymous]

Didnt understand you properly, might be asking to sort this order as per your requirement...

Properties-> Sort-> Expression to sort

Expression:

IF(Grounp&FunctionField='Agent - ABC', 1,

IF(Grounp&FunctionField='Agent - BBB', 2,

IF(Grounp&FunctionField='Agent - CCC', 3,

IF(Grounp&FunctionField='Agent - DDD', 4))))

With above expression you can change the order, hope this well help!!

[#3]

Hi Ramya ,

Have a nice day.

Small clarification  where your trying to do the sorting

any Object or edit script.

[Digvijay_Singh]

try Firstsortedvalue([Group Values],[Functions values]

[avinashelite]

could please explain what your trying to achieve ?? what value you need from the function ?

please share the sample output and data so that it will be helpful for us to understand