I have peer values that I want to rank in a single column to benchmark them against each other. I would also like these to include percentile ranks of the overall peer group, but I want the chart to include only values over a certain level. For example, these are some of the values I want to compare that I have analyzed in a pivot:
<TBODY>
</TBODY><COLGROUP><COL><COL><COL span=2></COLGROUP>
I care about benchmarking BBBB against their peers, as well as within the overall group. What I want is a single column that shows the overall population, a different color section of the bar for cases above my threshold, and a percentile rank for where they fall against their peers. Can this be done with my pivoted values, and if it can, how do I go about making these charts to include in my reports?
Thanks for your help.
| Activity Rate</SPAN> | (Multiple Items)</SPAN> | 1.0%+</SPAN> | |
| Sum of Activity Rate</SPAN> | |||
| Agency</SPAN> | Total</SPAN> | (Count)</SPAN> | (Rank)</SPAN> |
| AAAA</SPAN> | 1.7%</SPAN> | 1</SPAN> | |
| BBBB</SPAN> | 1.7%</SPAN> | 1</SPAN> | 2</SPAN> |
| CCCC</SPAN> | 1.6%</SPAN> | 1</SPAN> | |
| DDDD</SPAN> | 1.2%</SPAN> | 1</SPAN> | |
| EEEE</SPAN> | 1.1%</SPAN> | 1</SPAN> | |
| FFFF</SPAN> | 1.1%</SPAN> | 1</SPAN> | |
| Grand Total</SPAN> | 0.082233439</SPAN> | 6</SPAN> | |
| (Total Population)</SPAN> | 49</SPAN> |
<TBODY>
</TBODY><COLGROUP><COL><COL><COL span=2></COLGROUP>
I care about benchmarking BBBB against their peers, as well as within the overall group. What I want is a single column that shows the overall population, a different color section of the bar for cases above my threshold, and a percentile rank for where they fall against their peers. Can this be done with my pivoted values, and if it can, how do I go about making these charts to include in my reports?
Thanks for your help.
