Filter out a value of a dimension in a chart

[#1]

Hi,

I have a chart where I am trying to restrict the dimension values displayed in the chart.  I want it to show all the values for the proj_type_code field except ESG Activities.

This works:

=If (proj_type_code = 'ESG Activities', proj_type_code)

But this does not work:

=If (proj_type_code -= 'ESG Activities', proj_type_code)

Any help would be greatly appreciated

[swuehl]

Hi

I think you mismatched the use of -= with a set expression.

Why not try

=If (proj_type_code <> 'ESG Activities', proj_type_code)

?

Regards,

Stefan

[#3]

Please see the two attachements.  Image 1 is the chart before filtering on the dimension. Image2 is after applying the filter.  Its not displaying properly.

[johnw]

Suppress null values of the calculated dimension on the dimensions tab.

[swuehl · Accepted solution]

You used my expression as calculated dimension?

Have  you checked "suppress when value is NULL"?

[#6]

Yes.  In the meantime, I got it to work by adding the filter to my expression:

count({$<proj_mgr_name -={"Admin","*admin*"},proj_active_flag={"Yes"},proj_type_code -={"ESG Activities"}>}proj_nbr_id)

I'm just surprised that I can't seem to get this to work using a calculated dimension. 

[#7]

I didn't check supress value when null.  Its working now - thanks.