Groping and calculating counts by %

[#1]

Hello!

I have the following table:

TYPE MATCHING COUNTS

P Perfect_match 3

S Perfect_match 4
T Perfect_match 1
W Perfect_match 1
X Perfect_match 1

I would need to get the following table:

MATCHING TYPE_VS_COUNTS

Perfect_match {P}30%;{S}40%;{T}10%;{W}10%;{X}10%;

Amount of types can vary, so when I reload the data, there could appear new types. Could anybody please explain me the logic how can I do that in QV?

Thanks,

Andrei