Chart: Don't display a value of dimension

[#1]

I need to hide the values ​​that are shown with red line in the image below:

Is there any expression to do this or I need to change my sql query?

My expression is:

sum(Fundos_VOLUME)/1000

My Dimeenssion is:

=replace(Fundos_REDE, 'REDE DE AGENCIAS','') or just

Fundos_REDE

[rwunderlich · Accepted solution]

Make your dimension as

=if(NOT Match(Fundos_REDE, 'HAUER', 'PRIVATE COMPRADO'), Fundos_REDE)

and then check "Suppress when value is null" for the dimension.

-Rob

http://robwunderlich.com

[#3]

Greaatttt..

It worked. but how do I use the "Replace" function?

I did so. did not work

=if(NOT Match(replace(Fundos_REDE, 'REDE DE AGENCIAS',''), 'HAUER', 'PRIVATE COMPRADO'), Fundos_REDE)

Thanks but now I need to remove part of the text.

1. 

[#4]

Yeeeeh i got it.

like this:

=replace(if(NOT Match(Fundos_REDE, 'HAUER', 'PRIVATE COMPRADO'), Fundos_REDE), 'REDE DE AGENCIAS','')

thankss