How to display just those values in a diagram that exceeds a threshold

[thomaswrieck]

Hi,

I have a diagram with a dimension called DateMonthYear (e.g. July-2008) and the following formular

100-(sum(ShippingDelayCount)*100)/count(%SalesOrderID).

I just want to see in the diagram those months where the formular results in values <97%.

Hiow can I do that ?

Thanks a lot

Thomas

[#2]

yo can do something like this in your expression :

if( 100-(sum(ShippingDelayCount)*100)/count(%SalesOrderID)<97 ,100-(sum(ShippingDelayCount)*100)/count(%SalesOrderID) )