Hi,
I am trying to create a running total of fiscal year 2023 vs the same time in FY 2022 and FY 2021 but all on the same chart.
Right now, I currently have this
Essentially what I am trying to do is take the three green bars from July 1 of this year, combine them into one column and then do the same for the pink and blue. We have previously had someone here do all three columns with mySQL and when they have done that, the numbers don't turn out correctly.
Is there a way to group July, August and September of 2020, 2021, and 2022 together on one bar graph? The running total portion of that would be great so that we didnt have to figure out comparable week end for 2020 and 2021 each week as well.
TIA