Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
One more thing... would you be able to let me know the output you will see based on this sample you provided?