I have created a drill-down dimension with three dimensions. The second dimension, City, i would like to place a calculated condition on. =if(City = ', ', City). When I do this, the field does not display at all within the drill-down and goes from the first dimension to the third, by passing the second dimension that I am attempting to use the calculation on.
I have a field, 'City' that i do not want to display if the value is equal to ', ' so that is why I have the expression, IF 'City' is not equal to ', ' then 'CITY'
