I have an issue where I am getting the expected result from RANKCUMULATE when using one dimension, but when I add an additional scenario dimension to the module, it doesn't calculate the way I'd expect.
Here are some screenshots to explain the case:
Module 1 - calculates cumulative total for list items in list "Age" (cumulating up from 6 to 0) based on "FIFO Rank" line item. There is a "Product" dimension that I want to calculate seperately.
Here I get the expected result (1,000 + 2,000 = 3,000) for Product.Pensions and (5,000 + 5,000 = 10,000) for Product.Insurance.
Module 2 - takes the same module and adds a dimension called "Scenario" (highlighted green below):
Now the Cumulated Value doesn't give me the answer I expect (1,000 + 2,000 <> 4,600).
I have read all the documentation to RANKCUMULATE, and think I need to add the "Scenario" list to the Ranking Groups, but I don't know how I can do this? Or if a workaround is required?
Thanks in advance to anyone who can help.
