AGREGATION

[#1]

  Good morning, please, i need some help on this.

How can i get,  with a table of this kind of data:

MARKET	STATE_NAME	Sum
spain	Andalucia	1
spain	Madrid	3
spain	Valencia	5
spain	Galicia	7
portugal	Porto	2
portugal	Lisboa	1
portugal	Setubal	2

Obtein an objct table like this:

STATE_NAME	Sum
Andalucia	1
Madrid	3
Valencia	5
Galicia	7
portugal	5

Thanks a lot!

Belén

[#2]

I am trying to do something like this in Dimension..

if ([Market]=('Portugal'),'Portugal',[Region]) and if([Channel]=('on line'),'On line',[Region])

But this not works

[#3]

Hi,

Thy the below expression as Calculated dimension:

=if(MARKET = 'spain' and Channel <> 'On line', STATE_NAME,if(MARKET <> 'spain' and Channel <> 'On line', MARKET, Channel))

Expression could be Sum(Sum)

[#4]

Thanks a lot!