Setting criteria for minimal sales

[zagzebski]

This shoud be so simple but I am drawing a complete blank.

If I wanted to do something as basic as saying I want a dimension of SALES_PERSON and expression of Sum(Sales). Where would I add the crtiera to only pull back only SALES_PERSON with sales greater than 5000?

I tried to do it by checking the "Enable Condition" area on the dimension tab and adding sum(sales)>5000. I also tried to add to use the "Conditional" checkbox on the presentation tab and adding sum(sales)>5000 to the SALES_PERSON column. Neither worked.

I know this should be simple!

[Nicole-Smith · Accepted solution]

For your expression:

sum({<SALES_PERSON={'=sum(Sales)>5000'}>}Sales)

[gopalopsharma]

Hello Zagzebeski,

There is one simple method, to use "Dimension Limit" tab. You can explore and do a lot of things with this functionality.

One thing to be taken care of is that the Dimension limit is calculated only on the first expression in the chart.