Hi,
I have a pivot table with two expressions. One being a Percentage Rate and the other being the Denominator of the Rate (to give some context)
Pivot Table :
| Consultant | Within 7 Days | Total Units |
| Employee 1 | 100% | 1 |
| Employee 2 | 49% | 432 |
| Employee 3 | 44% | 157 |
| Employee 4 | 43% | 175 |
| Employee 5 | 32% | 205 |
| Employee 6 | 29% | 69 |
| Employee 7 | 25% | 142 |
| Employee 8 | 24% | 133 |
| Employee 9 | 24% | 228 |
| Employee 10 | 23% | 166 |
| Employee 11 | 23% | 229 |
| Employee 12 | 20% | 51 |
| Employee 13 | 19% | 37 |
| Employee 14 | 18% | 45 |
| Employee 15 | 18% | 34 |
| Employee 16 | 17% | 213 |
| Employee 17 | 17% | 190 |
| Employee 18 | 17% | 54 |
| Employee 19 | 17% | 24 |
| Employee 20 | 16% | 88 |
| Employee 21 | 16% | 273 |
| Employee 22 | 16% | 193 |
| Employee 23 | 16% | 206 |
| Employee 24 | 15% | 115 |
| Employee 25 | 15% | 227 |
| Employee 26 | 14% | 203 |
At the moment I am sorting on Rate in descending order. However, this gives a false impression of the performance of the employees as Employee1 has only 1 Unit. Is there a way in qlikview to order the Rate taking into account the number of units to give a more true representation?
Many thanks
