Forum Discussion
Help with a calculated field in a PivotTable
Hi, I am trying to write a formula for a calculated field inside a Pivot Table. I want to return the value 1 if the row value is equal to "New York", and zero otherwise. My formula is ...
I'd strongly recommend you start using DAX in the Power Pivot model if you want to write formulas in Pivot Tables. So much more flexible and powerful than Pivot Table calculated fields
The DAX would be something like this
If you've not used DAX before it is very different to how Excel formulas work
If this is of interest I can explain more.