CASE WHEN D's % of AOR = MAX(D's % of AOR) THEN 1 ELSE 0 END Some how this is returning the total for the column. All values are returning a 1.
one of the column in my dataset is $$$. However, it is in the Dimensions and will not calculate.