Hi, my question is..I want to use an If formula based on the Grp colomn value BU (see formula below), but it doesnt recognise the value as “BU”, it ju.

Excerpt from: 
pivot table calculated field or item in Excel Worksheet