2 Replies Latest reply: Jan 20, 2014 12:12 PM by Sharma Gopal RSS

    Setting criteria for minimal sales

    Steve 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!