Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Members,
The below code is working fine but I need to include an exclusion on it like "Group name != Retailer"
=if($(xTop)=10,if(aggr(Rank(Sum($(vGros2))),[Group Name]) <=10,[Group Name]))
With exclusion (Not working)
=if($(xTop)=10,if(aggr(Rank(Sum($(vGros2))),{<[Group Name]-={"Retailer"}>}) <=10,[Group Name]))
Please enlighten me.
Much appreciated for the help.
Cheer's
JP.
May be try this
=if($(xTop)=10,if(Aggr(Rank(Sum({<[Group Name] -= {"Retailer"}>} $(vGros2))), [Group Name]) <=10, [Group Name]))
May be try this
=if($(xTop)=10,if(Aggr(Rank(Sum({<[Group Name] -= {"Retailer"}>} $(vGros2))), [Group Name]) <=10, [Group Name]))
Dear Sunny, it work like charms. Thank you for the help.
Cheer's
JP.