Range dimension based on Amounts

[cognos_users]

Hi,

Please see the example below. The measure is count of distinct IDs. The dimension is Range which is defined based on the Amount field.  The requirement is to show the counts based on the amount range(calculated per ID: ID1 as Professor = 1000+600=$1600) for State and Profession.
The issue is in defining range since it varies from one dimension to other. In the example below if I define Range for State it does not match for Profession. How to define range so that it works and rolls up differently for State and Profession?

ID   State      Profession   Amount 
---------------------------------------------- 
1   California        Professor      1000
2   New York         Student    500
3   California      Student    500
1     NewYork       Professor       600


By State:     1-500    501-1000   1001-1500
--------------------------------------------
California          1         1            0
NewYork           1         0            0



By Profession:1-500   501-1000      1001-1500
----------------------------------------------------
Student              2              0           0
Professor                0            1             0   

[IceTea]

Think you need two range-dimensions:

1.) Range by State
2.) Range by Profession