I have operating budget that runs quarterly over 3 yrs. (all in 1 spreadsheet). How can I go about getting the variance to only show spend to-date variance, so I see budget-actual for all quarters to date (e.g. I want the variance to show that we are -200 to date for the 3 quarters passed rather than -47,000 for the entire 3 yr project).
Thanks in advance for any help!!
Bookmarks