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?
