Create Calculated Dimension

[#1]

Hi

I have a current "dimension" called NIVEL with several elements as shown:

Now I want to create a bar chart with a CALCULATED DIMENSION but including ONLY the GREEN shaded elements.

How can I accomplish this??

[swuehl · Accepted solution]

if you want to use a calculated dimension, maybe like

=if( wildmatch( Nivel, 'Total*'), Nivel)

[oscar_ortiz]

Or you can try

=If( NivelLike 'Total*', Nivel, Null())