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
Comments
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.