Forum Discussion
rolling 12 months
Hi All, Im looking at doing a rolling 12 months total. I have a list of employee id's and I have done a count of these then used the calculate to give me the max date, however when I put this in...
Greg_Deckler Many thanks for your response, but it didnt really resolve the issue.
I dont know if its possible, but if I use a bar graph as an example, and had 12 months worth of data bars, I would then look at Jul 23, that bar for Jul 23 should be a sum of the last 12 months in the 1 bar, then in the bar for May 23, it would be the sum of the last 12 months in that one bar etc.... so for each bar in the graph would be the sum up of that month plus the prior 12 months from that point in the month.
Hope that makes sense.