Month over Month Accumulation Sum

[gitguto]

Hello community, 

Is there a way to change the order of the dimensions using set analysis?

I need to display a month over month line graph in order to compare the values between different years.

The problem is that my measure is an accumulative sum from all prior periods, and when I use the Month as the first dimension, it accumulates wrongly as the lines are organized in a differente order, the example below will make it easier to understand:

When I change the order of the Dimensions (Year first), the measure is calculated correctly, because the lines are organized in the right order, but I get the wrong visualization:

Is there a way to have the first visualization with the right accumulation sum?

[rbartley]

Hi,

Set analysis is used to restrict the result, not affect the aggregation. Could you please post your app to make it easier to look into this?