Ordering Pivot Table

[#1]

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

[gautik92]

use rank function

[#3]

hi thanks for your reply,

Do you have an example please?