Hide a field in a dimension

[sweens78]

Hi Guys,

I have a chart below and I want to hide one of the fields in the dimension, any ideas, I know you can do it on a table but how on a chart?

[andrey_krylov]

Maybe editing expression

=if( not ThisField like 'Currently atten*', ... )

or set analysis {< ThisField -= {'Currently atten*'} >}

[vitaliichupryna]

Hi,

You can use set analysis. For example:
sum({<Category -= {"Currently"}>}Sales)
This expression will show sum of sales for all categories except of "Currently"

Thanks,
Vitalii

[sweens78]

Hi Andrey should it be the a edited Dimension I nned to add rather than expression?

I tried the first code but getting errors?=if( not ThisField like 'Currently atten*', ... )

[raman_rastogi]

Try this

Calculated dimension

if (dim='value',' ',dim)

and Suppress null values for dimension.

Regards

Raman

[rajivmeher]

Hi Martin

Have you tried puting the following condition in dimension?

IF(Field_Name <> 'Currently atten'(please mention the full value here), Field_Name)

You can go into dimension tab, select the dimension and edit it. Add the above expression and see if the dimension value gets hidden in the chart?

Regards

Rajiv.

[andrey_krylov]

This can be both an expression and a dimension, as suggested by Raman and Rajiv. You need to determine what field is used in the chart and put it in the formula.

1. Dimension:  = if ( field <> 'Currently atten...', field )

            'Currently atten...' -   this value must be completed. And Suppress null values

2. Expression: to the used expression add this condition, for example

          sum( if ( field <> 'Currently atten...', Amount ) )

          or in set analysis  sum( {< field -= {'Currently atten...'} >} Amount )