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.
To calculate based on the prior month, transpose your data to vertical, and then filter out on the dates that include the current month and beyond. This is done with a few date functions, to pull a text string representing the month, from the text month header.
The Value column from the transpose tool becomes the second row in the result, so renamed it with a select tool as Row2.
2 Multi-Row formula tools create the totals, and pull in values from the previous month, if later than the current month.
Another transpose tool breaks out those new columns into rows, so that we can build the desired table.
Rearrange to the correct order with a Sort, and then rebuild your table with Crosstab.