Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be something like this in your set analysis expression:
{<Country = e(Country)>} or
{<Country -= p(Country)>}
Belen,
If your expression is
=Sum(Sales)
to calculate this with the excluded values of markets:
=Sum({<Market=e(Market)>} Sales)
Marc.
try like :
=sum({<Agent=e(Agent)>}cost)
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?
Ok! Thanks Sunindia