Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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)
Thanks a lot!