My Excel spreadsheet looks like this
I created from this dynamic data table:
I need to add another "bonus" column where the value will be calculated according to this criterion.
Therefore, the result should be (but the bonus should be part of the pivot table):
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.