on 09-23-2008 9:05 AM
Hi experts
I have an issue with query design. The base request I have been given is to produce a report that shows by shop, sales achieved as a list. The request is also to highlight the best (max) and worst (min) performers against all the others.
Thus:
Store Sales
A 20
B 60 <- best, highlighted
C 15 <- worst, highlighted
D 30
I have tried Exceptions but this seems to only work for explicit values, not against all the possible values in the list. The report will be automated and the best and worst thresholds will change everytime, so the solution would need to be dynamic.
Thanks in advance.
Using BI 7
Hi,
You can do it by Exceptions.this is the best way for highlighting those MAX , MIN values.
Regards
Pcrao.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thank you for the fast response, however as I tried to point out in my original post, when I try exceptions it only gives me the option to set explicit boundries.
The max and min values change everyday and this report will publish to a schedule everyday.
What I'm looking for is a way to have the max min values be set at run-time based on the data in the report.
Any ideas?
Hi Experts,
is there any answer to this question.
I have the same problem. I know how to set exceptions for static values green < 1 or red >= 1. It's very easy. But what if I don't know what results are coming.
on first run of the query I got the values:
15
34 <== highest value to be highlight
5 <== lowest value to be highlight
24
on the second run I got:
32
24
9 <== lowest value to be highlight
74 <== highest value to be highlight
That can't be so difficult, isn't it?
Thanks in advance.
Best regards Nico
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.