Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?