Rank calculations based on 2 diffrent search criteria

[#1]

Hello All,

Need some help. Currently i have 2 search objects

Search Object 1: User Can select on - MasterName or MasterNum

Serach Object 2: User Can select on - Name or Num

Currently i have 2 Expressions to calulate the Ranks:

Expression 1 (Based on Search1): aggr(rank(sum({<MasterName=,MasterNum=>}Net)),Product,MasterNum

Expression 2 (Based on Search 2): aggr(rank(sum({<Name=,Num=>}Net)),Product,Num

I'm basically looking to achieve the Rank calculation using only one set of expression based on which search object the user selects.

Thanks

[bgerchikov]

Hello,

You can create trigger event to assign your expressions to variable, then use this variable in Set Analysis as expression.

Hope it will help.