Hi All,
I have below straight table:
| CYTD approvals | CYTD Claims | PYTD approvals | PYTD Claims |
| 1200 | 300 | 1100 | 200 |
The dimension is
Month(hidden)
Expressions:
Mon - only({CrdtMonthNumber = {$(=Max({<Year = { $ =Max (Year))}>}CrdtMonthNumber ))}>}Month)
CYTD approvals = sum(Total {<Year = {=Max(Year))}>}Approvals)
CYTD Claims = sum(Total {<Year = {=Max(Year))}>}Claims)
PYTD approvals = sum(Total {<Year = {=Max(Year)-1)}>}Approvals)
CYTD Claims = sum(Total {<Year = {=Max(Year)-1)}>}Claims)
Now the requirement is , we have to add classes dimension to this. We have 3 Classes and so the table should have 3 rows . Something like this for the above table.
| Classes | CYTD approvals | CYTD Claims | PYTD approvals | PYTD Claims |
| A | 600 | 100 | 500 | 100 |
| B | 300 | 100 | 300 | 50 |
| C | 300 | 100 | 300 | 50 |
When added the Classes dimension its not distributing the values. Rather its showing the total in all the rows. Any help would be appreciated.
Thanks,
Anupama Jagan
