Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved.
Learn more here!
I used a crosstab tool to aggregate. I cheated a bit by taking advantage of the fact that the AW100 field was always 1. If it wasn't I would have added a field that was all 1's.