0

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.

New contributor
Zcela Anonymní is a new contributor to this site. Take care in asking for clarification, commenting, and answering. Check out our Code of Conduct.
  • Possible method 1 is,, pull source data to DATA MODEL & apply DAX formula to calculate the Bonus,, Method 2 is,, apply Calculated field to existing PT and use IF else logical formula for BONUS. And in worst case with Source data add new Column Bonus and add to the existing PT. – Rajesh S Feb 15 at 6:23

Your Answer

Zcela Anonymní is a new contributor. Be nice, and check out our Code of Conduct.

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.