Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jordanebyrnes
Starting Member
1 Post |
 Posted - 2012-03-16 : 12:07:23
|
| I have a list of Sites and a Volumes associated to those Sites. The list of Sites is different depending on what's been filtered.I need to conditional format the cells based on Quintiles - so 5 sections i.e. Red, Orange, Light Orange, Yellow, Green. This will show the top 20% of Sites etc etc...How can I write the calculation of these Quintiles in the Format Cell expression? Or do I need to add a new calculation to a new dataset and use that? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-03-16 : 12:18:52
|
| use NTILE() function to generate quintile value from sql and then use it in conditional expression for background color------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
Quintiles in Report Builder