· Mar 29, 2017

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


Discussion (2)1
Log in or sign up to continue

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: