exclude the selection in a expresion

[#1]

Hello,

I need to do a table as follow:

If i select one country ( Country1), a table that contains the cummulate of all markets but the one selected. If i select other country the same excluding this selection.. Always excluding in the expresion the country selested. is this posible?

MARKET   (w/o selection)	5
COUNTRY 1	3
TOT	8

MARKET   (w/o selection)	6
COUNTRY 2	2
TOT	8

Thanks

[sunny_talwar]

May be something like this in your set analysis expression:

{<Country = e(Country)>} or

{<Country -= p(Country)>}

[Anonymous]

Belen,

If your expression is

=Sum(Sales)

to calculate this with the excluded values of markets:

=Sum({<Market=e(Market)>} Sales)

Marc.

[avinashelite]

try like :

=sum({<Agent=e(Agent)>}cost)

[#5]

It Works, but it is posible to do do the filter in the dimensión? So in this case i can have the Market without the selection and the selection?

[#6]

Ok! Thanks Sunindia