Excel pivot table: see the external pivot table if not

My Excel spreadsheet looks like this

enter the description of the image here

I created from this dynamic data table:

enter the description of the image here

I need to add another "bonus" column where the value will be calculated according to this criterion.

enter the description of the image here

Therefore, the result should be (but the bonus should be part of the pivot table):

enter the description of the image here

The price is calculated by the sum of the prices sold *. But there is a condition based on the business / customer category. I wonder how I can refer outside the pivot table by formula and how to create, if not for parrent.

I discovered that I can refer outside the pivot table by formulas in the data model, but I am struggling with the creation of some real formula.