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

[luis_pimentel]

The easiest way it will be in your load script, do something like:

LOAD

     MARKET,

     STATE_NAME,

     IF (MARKET = 'Portugal', 'Portugal', STATE_NAME) AS STATE_NAME_AUX

FROM yourfile...

and then use STATE_NAME_AUX as a dimension, and sum(yourvalue) as a expression.

Hope that helps.

[MK_QSL]

Can you share your application or sample file?

Not fully understood your requirement from your question

[#4]

What i want is to do it from the chart, in properties Dimension. As a calculated dimensión, if posible.

Thanks

[#5 · Accepted solution]

Hi,

Use the below calculated dimension in your chart.

=if(MARKET = 'spain', STATE_name,MARKET)

[#6]

Thanks Venugo, That fits with my problem.

Other question... it is possible, also with other file, ( also in the dimensión):

From this data:

MARKET	STATE_NAME	Sum	Channel
spain	Andalucia	1	C.C
spain	Madrid	3	Other
spain	Valencia	5	On line
spain	Galicia	7	Other
portugal	Porto	2	On line
portugal	Lisboa	1	C.C
portugal	Setubal	2	Other

Get a table object like this?  Taking  also On line and Portugal inside the table whith the state_name

STATE_NAME	Sum
Andalucia	1
Madrid	3
Galicia	7
On line	7
portugal	3

Thanks a lot!

Belén

[#7]

Hi,

Try with below in your expression.

Sum({<Channel -= {'On line'}>}Sum)

[#8]

Is not working.....

=if(MARKET = 'spain', STATE_name,MARKET) Sum({<Channel -= {'On line'}>}Sum)

all together?

[MK_QSL]

Below should be in script

=if(MARKET = 'spain', STATE_name,MARKET as STATE_name

Below as table or chart expression.

Sum({<Channel -= {'On line'}>}Sum)

[#10]

Hi,

Use Dimension as : =if(MARKET = 'spain', STATE_name,MARKET)

and Expression could be : Sum({<Channel -= {'On line'}>}Sum)