This content has been marked as final. Show 2 replies
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!