Forum Discussion
JC2022
Helper III
Helper IIICumulative Sales lines
Hi, The line graph below is my goal. I would like to create a cumulative sales line for the current year (blue line), the current year -1 (green line) and the current year -2 (red line). All the li...
BeaBF
Super User
Super UserTo display all 12 months on the x-axis starting with October, you can create a custom calendar table with a column for each month in the fiscal year. You can then join this custom calendar table with your sales data using the fiscal year and month offset columns.
BBF
JC2022Helper III
Helper IIIbut the Current Year Sales still shows more than the current year right? For example there is a value for [CurMonthOffset] = -20. Plus it shows a value for [CurMonthOffset] = 1 while the line should stop at 0 (and the line between -1 and 0 is then dotted)
By the way is it something strange I am trying to reach as an endresult? What is a more convenient manner to visualize this?