Empty Columns and ZN() won't work in this case as there is nothing in the dimension for December 2017.
If you bring in a record for December 2017 of 0 then you will see a result, which you can change when you get the data.
Suppose you are displaying a measure X for the year 2016 & Y for 2017.
Write a Calculation for the Measure of 2017.
If y = ' ' then 0 else y end
Hello Zhouyi Zhang,
Your solution works fine with the example but the real problem I have to solve is related to a SQL data-source, not a text-file.
In this case the function MAKEDATE is not recognized. Can you think of another function or a workaround to help me ?
In fact I found the adaptation to the solution by myself :
I created a calculated field to extract the month of the date
Then I constructed a bin on it going from 1 to 12 with a step of 1
then I used this new created field as dimension and parameter to the running sum.
Have a look at the attachment if you are interested in it.
solution.twbx 10.9 KB