I have a data set that is categorized by "cumulative" and "monthly" data (see Reporttype below). I want to show the monthly data per month, but only the cumulative data by the last month. I have searched around and tried various solutions but nothing is working correctly.
Here is what the data looks like, for the cumulative I only want the last month to display:
When I try to date trunk, it also removes the months from the "monthly" category. This also happens when I "hide" the extra months in the "cumulative" category.