Counting occurrences and creating a new table and finding percentage based on total

[Anonymous]

Hi Experts

I am trying to count the number of occurance in a particular column in my table then create another table with list the number of occurance for each Product in a new table and the create a third column in the new table to show the percentage of each product as a percenatage value based on the total.

Start

Product A       1

Product B       1

Product A       1

Product B       1

New Table

Product A      2   50%

Product B      2   50%