Exclude field selection

[paulwalker]

Hi Community,

How to exclude field selection in Textbox, i have written in set analysis

like Sum({<Country=>}sales)  this is working fine.....

But, i have used AGGR function in my expression, not working

Ex:  Count(Aggr(Sum({<Country=>}sales), client))  this expression not working for exclude Country level.

is there anyway to exclude whole sheet ??

Thanks in Advance....

[sunny_talwar]

To exclude selection in all selections, you can try this

Sum({1} sales)

[paulwalker]

no, i want to exclude one field only

[sunny_talwar]

I guess try this:

Count({<Country=>} Aggr(Sum({<Country=>}sales), client))