From the sample query result below i need to be able to report the total average KGs Picked by the top 10%, 50% and 75% of IDs listed.
Picker ID KGs Picked
151319 109.55
150743 107.38
150859 103.55
150841 94.29
150878 90.46
150929 86.63
150839 82.29
151030 79.55
150651 76.29
150393 76.29
150373 70.29
150857 70.29
100100 70.03
100726 69.20
This one's a bit beyond my limited Access skills. Can anyone help?
Tony Black
Picker ID KGs Picked
151319 109.55
150743 107.38
150859 103.55
150841 94.29
150878 90.46
150929 86.63
150839 82.29
151030 79.55
150651 76.29
150393 76.29
150373 70.29
150857 70.29
100100 70.03
100726 69.20
This one's a bit beyond my limited Access skills. Can anyone help?
Tony Black