I need to create a YTD (Jan-Apr) column for current year and prior year. I have multiple rows that need calculated. See attached.
Need:
Current Year YTD Actual
Current Year YTD Budget
Last Year YTD Actual
Thanks!
Solved! Go to Solution.
Thanks @LordNeilLord However, I have to have new, separate columns next to my existing data. If I do this, I believe it will override my current month to date data. I need my output to look similar to this
Date FSParent Actual Budget Last Year V_Budget V_Last Year YTD Actual YTD Budget YTD LY
Yes, exactly what I needed. Thank you!