Dollar Ranges
How to setup dollar ranges to get the number of patient accounts. So, I want to capture the number of patient accounts based on the original balance of:
0 to 499
500 to 999
1000 to 2499
5000 to 9999
10000 to 24999
25000 to 49999
50000 to 74000
75000 to 99999
=100000
Depending on the structure of your cube, you might be able to do this with a set of calculated members using range expressions and the %OR MDX function.
For example, here is the MDX expression for a range of 1 to 3 units sold using the Units per Transaction dimension in the HoleFoods cube:
%OR([UnitsPerTransaction].[H1].[UnitsSold].&[1]:&[3])
Or maybe you can introduce a cube dimension with a ranged expression for the property of balance and range all the patients to these groups.
See examples in Samples PatientsCube for patients ranged similarly by their age.