Formula/Chart representing percentages

Hi, I have a spreadsheet with many rows representing records, and columns of different types of data. Column 1 indicates what region the record falls under and there are 8 regions in total. Column 2 is numerical and for each row, there's a number assigned. For example, 1 row might fall under region Japan and column 2 might have the number 17, while the next row might fall under region Southeast Asia and under column 2 it'll have the number 9. Some rows don't have numbers in column 2 at all, which indicates 0.

I want to create a chart that expresses the number of records with a number in column 2 relative to the total number of records. e.g. let's say there are 100 rows falling under region Japan, but only 56 of them have a non-zero number in column 2. Thus, the chart should show Japan at 56%. Does this make sense?

How would I go about doing this? Do I first need to create another table with formulas that calculates these percentages, then create a chart from this? If so, does someone have a sample formula I could use that helps to check through the spreadsheet for relevant rows of each region and takes note of whether they have a non-zero number in column 2?

Thanks!

To elaborate, here's an example:

Region Number
Japan 2
Japan
SE Asia 4
Korea 17
Japan 8
Japan
Japan 3

So, Japan would be at 60% in this case, since there are 5 Japan rows but only 3 of them have a non-zero number

Hey, thanks for the reply - posted an example above

Thanks guys, that's exactly what I was looking for - but I can't figure out how to replicate this on my spreadsheet? I see that you're using the pivottable feature, but I'm not sure how to go about using this. Could someone guide me through it please? Much appreciate the help