How can I get my NPS score to populate with a calculated field

[yakhtar]

Hi I have a Pivot table with my NPS score. How can I use calculated field so it populates?

Formula is (Promoted-Detractors)/(Promoted+Passive+Detractors)

Thanks in advance!!!

 

[pjmorris]

use PowerPivot to create a 'Measure'. First define each of the terms, perhaps Promoted=sum(table1[promoted]) for example. Then combine them into the NPS Score.
If you're not familiar with PowerPivot there are some good tutorials online and also readable books - it will be worth the effort.