Sum with exclusion

[Jalu]

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.

[sunny_talwar · Accepted solution]

May be try this

=if($(xTop)=10,if(Aggr(Rank(Sum({<[Group Name] -= {"Retailer"}>} $(vGros2))), [Group Name]) <=10, [Group Name]))

[Jalu]

Dear Sunny, it work like charms.    Thank you for the help.

Cheer's

JP.