Grouping values

[mibb1234]

Hello,

I have data for vehicle registration and Movement count. I want to group these not by serial but by count.

e.g.  "16" movement count - 2 vehicles , 2% of all movements

Thanks

HN51 CWM	17
GL52 XOO	16
OJ69 BVU	16
GS57 IGF	15
UX69 UMP	15
CM58 HNQ	15
PA66 BSA	13
RC63 IFF	13
LT61 TTK	13
KN57 GNM	13
QP68 ZVX	13
MI61 VJY	13
JX65 RKR	12
IT52 TZL	12
HV61 EDP	12
LS69 BBP	12
IU52 NAK	12
QV63 QYJ	12
CO67 UNO	12
BO58 HGZ	12
TN59 ZPF	12
TE53 SJV	11
TA69 VME	11
HY52 PIQ	11
WY69 OCK	11
DO63 PRF	11
EU64 IBZ	11
DF53 QNT	11
NC64 MUY	11
AU61 LAP	11
LF55 OFF	11
FM59 MIE	11
XR67 KPE	11
OA68 YZL	11
KS67 PMK	11
XU67 BGD	10
MM66 BRN	10
BJ65 IKA	10
EN61 TKZ	10
KZ67 WWW	10
QO56 RGF	10
FP65 XNX	10
IO67 MIF	10
LY66 IXU	10
IE52 PPF	10
CW62 VFU	10
CS64 JBX	10
TP63 IJU	10
JF66 VAI	10
YC63 IAJ	10
JV57 ENE	10
VQ59 QEG	10
FC67 VNJ	10
AI59 OXR	10
MU53 BER	10
HK62 ZNX	10
TF66 VPB	10
YN69 ONF	10
ET67 CTQ	10
EM55 ADB	10
JR62 ZMN	10
SG67 JUF	10
AY52 PJP	10
YI67 SSD	10
QX66 VZB	10
LG61 YVH	10
UJ62 FEF	10
SR61 IGU	10
IK66 ZOO	10
VY51 APV	10
CJ57 VHH	10
GY68 RLR	10
DY59 OBI	10
AH56 HTY	10
CU56 PVL	10
IG54 CAV	10
JK63 DRH	10
EL61 HMK	10
ID62 UOF	9
JK52 RLD	9
MR51 FAE	9
MK58 PFK	9
YK62 YAX	9
PJ67 NCN	9
OQ64 GGN	9
HH58 ZHK	9
FL61 NFX	9
AP53 XLK	9
PC61 VRM	9
JO55 YJD	9
ST53 XRN	9
AF53 GYI	9
BQ56 BZF	9
YC62 HMJ	9
TQ53 ZZV	9
NQ54 MXL	9
CJ62 MIL	9
LC51 XRD	9
GY63 UGO	9
GK53 SIL	9
OT56 KDH	9
KA53 SKT	9
YJ59 CXB	9
AG67 AKP	9
VE58 KOX	9
NN54 DRZ	9
AO67 QZL	9
VK56 SBM	9

[zhadrakas · Accepted solution]

This script should do it. 

BASE:
LOAD * INLINE [
ID, VEHICLE, COUNT
HN51, CWM, 17
GL52, XOO, 16
OJ69, BVU, 16
GS57, IGF, 15
UX69, UMP, 15
];

AGG_BASE:
Load COUNT,
COUNT(VEHICLE) as AMOUNT_PER_COUNT
Resident BASE
GROUP BY COUNT
;

[mibb1234]

Thank you very much