Percentage of Total sum

Hi community
I have a table with the categories: Year, Month, Scrap number, Scrap category and Number of products produced. I want to know how many of the total produced products that are scrap products for each month and in which category.

By the use of a pivot table I sum up the number of scrap parts in every category for each month and I also get the Total number of produced products for each month but what I don't know how to do is how I can get the percentage of scrap product for each category in regards to Total products produced.
(See attached excel document)

Thank you for your help!

Kind regards
Toobor

Hi Toobor,

Rather than a pivot table you could use the SUMIF function to create a simple table (see attached).

Snook

Amended to incorporate the month using the SUMIFS function.

Hope this helps.

Snook

Thank you The_Snook for your quick answer.

The problem with your solution is that I also want to show the result per year and month. It is possible to add another SUMIF which inspects the year and month but then the equation gets pretty complicated. I also like to be able to update the table with new data and new dates in the future without the need of doing any manually work which then can be a problem when a new year starts.

You could add the year as an additional criteria in the SUMIFS formula (see attached).

Snook

I tried that too but in that way I don't get the percentage in regards to the total products produced. Instead the percentages for each category is calculated with the number of products produced which has scrap products with that specific category.

total for specific month