How to group a crosstab row on the basis of measure value

[semsel]

I have a crosstab with rows Grade,Customer. The customer is grouped according to their grades Grade A, Grade B and sorted accordingly.

In the columns I have the measures[LastYear Overdue],  [Total Balance], [Current Overdue]
Grade Calculation is as follows:

If [Current Overdue]/[Total Balance] <0.1 and [Current Overdue]< 100 then 'Grade A'
else if  [Current Overdue]/[Total Balance] <0.2 and [Current Overdue]< 200 then Grade B else Grade C like that.

The customers are correctly grouped now, but it is affecting the values of the measure [Last Year Overdue]. It shows 0 for all grades except Grade C (the else part).

Is there anyway to relate the customer code with the Grade such that the other measures are not affected?   How do I bring the customer code into the Grade calculation ?


How to Classify a customer as Grade A,B etc ?

[Lynn]

Is your source relational or dimensional?