The idea here is to expand the formula editor (Specifically CASE WHEN Statements) to allow the creation of dimensions or "buckets" based on filtered data. This is useful on the dashboard level as we ...
I realized after posting that I forgot to put that first formula into a MPA, so it'd need to be more like:
SUM ( [Customer ID] , IF ( [Avg Money Spent] > 999 , 1 , 0 ) )