Would it be possible to create a line chart as this?
The amount calculated is in % and that is as shown below in the formula a cummulative. For instance, in a given month, lets say 7 - July, the % is calculated as the total sum from january to july of value A devided by the same range of sum for value B.
Thank you very much in advance!
Yes, For me it is possible since you are using Qlikview. Please share some sample data to work
That works otherwise, Share the QVW with excel file to save time
Thank you that was really helpful,
To make it more challenging, would it be however possible to consider the rolling effect from January and on and leave December 2019 alone as is?
The offset variable doesn't produce me the correct results if i were to set it as 1 or 2.
Attached is the Excel with the formula and the december 2019 added in it.