Exclude a specific dimension value from a chart

[jerryr125]

Hi

i have a Dimension (daycat) with the following values (and only these values) :

A

B

C 

Other 

I would like to exclude “other” automatically without having the end user to  filter it out.

thoughts ?? Jerry 

[trdandamudi]

Use the below expression as your dimension in the chart:

=If( Not [Type] Like 'Other' , [Type])

   OR

=If(Not WildMatch([Type], 'Other'), [Type])

OR

You can use the below as expression:

Sum({<Type -={'Other'}>} Amount)

NOTE: Substitute your field name for 'Type'

[jerryr125]

hi - my 'Type' field is a master item dimension (DaysCatOrder).  Does not work - any thoughts  ? jerry

[trdandamudi]

Can you please post a sample, so that I can see what I can do.

Thanks

[jerryr125]

Here is the Master Item Dimension expression:

MasterItem: DaysRR

=IF($(Days-Request-to-Requisition) >= 0 and $(Days-Request-to-Requisition) <= 3, '0-3',
IF($(Days-Request-to-Requisition) > 3 and $(Days-Request-to-Requisition) <= 5, '3+-5',
IF($(Days-Request-to-Requisition) > 5 and $(Days-Request-to-Requisition) <= 10, '5+-10',
IF($(Days-Request-to-Requisition) >= 10, '10+','NA'))))

Here is the results:

I do not want to show the NA bar

[trdandamudi]

By excluding 'NA' in the expression should drop that bar automatically. Something link below:

=IF($(Days-Request-to-Requisition) >= 0 and $(Days-Request-to-Requisition) <= 3, '0-3',
IF($(Days-Request-to-Requisition) > 3 and $(Days-Request-to-Requisition) <= 5, '3+-5',
IF($(Days-Request-to-Requisition) > 5 and $(Days-Request-to-Requisition) <= 10, '5+-10',
IF($(Days-Request-to-Requisition) >= 10, '10+'))))

Hope this helps.