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 ?
Is your source relational or dimensional?