Hi,
I'm facing an issue with the use of running sum in a chart comparing data from previous year (full view) and current year (up to previous month)
What I need is to have on the same chart : running sum of sells amount per month for previous year, and running sum of sells amount up to previous month of current year.
I have to queries: one for previous year sells (taking them all for previous accounting year) and one for current year sells (up to previous month of current accouting year).
To create my chart, here is how I proceeded :
* X-axis : I merged the month as string dimension of the two queries and uses it as X-axis. To be noticed that our accounting year starts on September, so I made a custom sort to ensure first month is not January.
* Y-axis : I created two variables with running sum of sells amount (one per year, previous and current), that I added to my chart.
The problem I have is that if I make a simple "running sum", it extends "current year"-dots even after last month. And if I add a condition in my formula like "if amount is > 0 then running sum(sells amount)", I get some missing dots for previous months, as I may have month without sells.
What could be the best option to get proper representation of my current year running sum in this context ?
I thank you very much for your help and time,
Maxime
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.