How to exclude values Greater Than a certain number in a Measure for a chart?

[jblomqvist]

Hi all,

How can I exclude values greater than a certain number based on a Measure in a Chart?

For example in the chart above I would like to exclude Sales greater than 400,000.

My dimension is CategoryName

Expression = Sum(LineSalesAmount)

[tresesco]

Sum({<CategoryName={'=Sum(Sales)>400000'}>}LineSalesAmount)

[marcus_sommer]

Take a look on the options in the tab restrictions within the object properties.

- Marcus

[Anonymous]

goto tab Dimension Limit, there oyu can define your Limit less than

[Chanty4u]

try

Sum({<Sales={"=>40000"}>} LineSalesAmount)

[jblomqvist]

Perfect, you all have provided the right options! Thank you