https://1drv.ms/x/s!AvjBsEPEq12ngTsi...MJ1_h?e=YIGtSL

I wish to add the total for B and C in the Pivot Table like in cell D6.

Suppose I update my PV and more data is added.

How do I make it such that I can calculate the total for Company B and C and get $300?

Hope that makes sense. Thanks