Have you considered setting up a dimension table like "Customer Tier" that has a row for each bracket you want (e.g. 0 - $10k,$11K-$20K, etc.). You could then join your fact table rows to the appropriate Customer Tier in your fact table load procedure. Once this is set up, you can set up an OLAP dimension for Customer Tier that would give totals for each bracket.