Still not very clear for me, how the percentage column mentioned above is calculated to get? Are you already getting the percentages for each category individually, and you want to get the percentages for all categories in total?
If we know exactly what you are trying to achieve, you might be able to get a solution faster.
As a general advise, please, provide:
Sample (dummy dataset) data as text, use the table tool in the editing bar