This has been around so long, the original question has been lost to the discussion. I wanted a YTD report for the same YTD period but spanning a number of years. For example, a YTD for the six months ending June 30 that compares that same period over the past five years. The solution you suggestion does not do that. If you make the period 1/1/2015 to 6-30-2019 and display columns by year, you'll get the full years for 2015 through 2018 and six months of 2019. You might think the P&L YTD Comparison would work, but it won't. I've found a way to do this. It's not simple, but at least it works--see PDF attached. Confession: I don't remember if I invented this or got it from someone else. If it's your invention, please let me know, and I'll gladly give you full credit for it.
... View more