Percentage in column D related to number in column C and subtotal in column B

Hello

I have a large file (200000+ rows) for which I created a pivot table. In a calculated field in column D I would like to get a formula to calculate the percentage, based on a number in column C and a subtotal in column B.

Example:

Axes: Month, Colour, Days (difference between order date and delivery date)

Column B: number of articles ordered, subtotal per month by pivot
Column C: number of articles delivered, subtotal per month by pivot
Column D: percentage of articles delivered in relation to subtotal of articles ordered

Attached is a small dummy file.

Any help is more than welcome.

Thanks
Chris

Hello Bernie

Thanks for your reply. I did what you did before, but then the result of the calculation is not as wanted.
In the dummy file for the IND II color, the subtotal of ordered is 59 (cel B9), as sum of 58 pieces ordered (B10) on 1 day (A10) and 1 piece ordered (B11) on 5 days (A11).
The formula now calculates the percentage of pieces delivered (column C) in relation of the pieces ordered (column B). As such the formula gives in D10 91,38%, being 53 delivered of 58 ordered.
What I'm looking for is the percentage for 53 delivered (C10) of 59 (B9) and the percentage for 1 delivered (C11) of 59 (B9).
This then should be calculated for each color (ie each subtotal and its corresponding rows: C15 and C16 to B14).

Is this making any sense? Is this possible?

Chris

This works fine, thanks.
The problem I'm facing now is to get a chart from the combination of the pivot and the extra column added.
Can I get a chart showing the color and the percentage?

In the original file (over 200000 rows) I use slicers to filter the data in the pivot table, so the data to fill the chart change every time.
The calculated percentage remains OK, but I don't succeed in putting this in a chart.
I tried the simple formula as you suggested, but no result.
Any help?

Chris