Is it possible to compare a month with the previous month?
I am currently trying to design a report where I only see values when the value changes over the months. It should look like this
The months between those shown in the example should be made invisible as they have the same periods (for example the months before Aoril 2022 have the same value and only in April it changes). I tried to do that by making a user dimension with a dynamic month for the current month and one for the previous month. But the problem is that the periods are placed next to another and not as I thought that the value of for example February is placed next to the value of January. but my current report looks like this:
The line for July was supposed to have the value of June next to it but the values are the same. Is that even possible? The crosstab looks like this:
Can I even compare months of the same year? Comparing months of different years is easily made but I stumble with periods for the same year.