My Excel spreadsheet looks like this
I created from this data pivot table:
I need to add another column “bonus” where value will be calculated on this criteria.
So result should be (but bonus should be part of pivot table):
Price is calculated by sum of sold * pricing. But there is a condition based on business/customer category. I’m wondering how can I refer outside of pivot table by formula and howt to create if else for parrent.
I found out that I can reffer outside of pivot table by formulas in data model, but Im strugling with creating some actual formula.