This content has been marked as final. Show 10 replies
I'm trying to create a calculated dimension using an "if(or..." conditional expression.
The statement is: IF(OR(FieldA = 'Value1', FieldA = 'Value2'),"Value 1,2", "NotValue1,2")
But I get errors. I'm using typical Excel conditional formatting syntax, assuming this would apply.
My objective is to get two cases: a) Value 1,2 and b) NotValue 1,2
and then use these in a pivot table to show summary results.