Hi all

Im trying to work out how I what a percent of a total is of the group.

623458 <- grouped     Total
623458   Cable 1mm     12
623458   Cable 2mm     0
623458   Cable 4mm     4
623458   Cable 7mm     0
623458   Cable 10mm    5

I need to total up the items that are 0 and display it as a percentage of that group. In this case it would be 40%.



not sure how to go about it.