Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)/1000My Dimeenssion is:
=replace(Fundos_REDE, 'REDE DE AGENCIAS','') or just
Fundos_REDE
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
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
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.
Yeeeeh i got it.
like this:
=replace(if(NOT Match(Fundos_REDE, 'HAUER', 'PRIVATE COMPRADO'), Fundos_REDE), 'REDE DE AGENCIAS','')thankss