Calculating Variance , Current Month - Previous Month

ankush-agrawal

Hello I have a data set for which I keep adding Current Month data into excel.

Alteryx workflow is designed in a way that it groups the data at account level with months as column.

I need to add variance column at the end which calculates variance between current month minus previous month.

I perform this exercise in first week of every month and Current month Data means data of last concluded month.

For eg:

Expectation in June: Current Month Data (2022_5)- Previous Month (2022_04)

Expectation in July: Current Month Data (2022_6)- Previous Month (2022_05)

Attaching the data set for reference.

Data Set.xlsx

binu_acs

@ankush-agrawal One way of doing this. I added an extra column 2022_05 to calculate dynamically

Variance_08_06.yxmd