Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
For your expression:
sum({<SALES_PERSON={'=sum(Sales)>5000'}>}Sales)
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.