look for first idea and let me know what do you think about this direction?
comm_cummarg_thr_115550.qvw 1.4 MB
as tech_month i named additional dimension connected to oryginal month dimension.
Each tech_month value is connected to oryginal months used in your cumulated calculations.
So, we have data structure like this:
thanks it for example 5'th tech month "knows" months, and, what is most iportant, also data for months 1-5.
So, if we put tech_month as dimension, we will have in each row of our chart data from all month we would like to accumulate in this row.
Of course it is still possible (uing set analysis) to show in this row some other KPI using data, where tech_month=month.
Let me know if you have additional questions or need more help.