Development User Help

excel pivot table – refer outside pivot table if else

My Excel spreadsheet looks like this

enter image description here

I created from this data pivot table:

enter image description here

I need to add another column “bonus” where value will be calculated on this criteria.

enter image description here

So result should be (but bonus should be part of pivot table):

enter image description here

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.

Leave a Reply

Your email address will not be published. Required fields are marked *