This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
By Transposing your columns into one column and doing a little data prep, you can calculate which month you're currently in based on max date and then summarize the values for any dates that include months that are <= to the current month. You can then Summarize and Cross-Tab the results to calculate the YTD values for this year & prior year.