Calculating previous month based on current month selection

I have built the attached workflow. Now, the requirement is that I need to convert it into an analytic app and allow the user to select any month of any year. Based on the selected month, the previous month of that year should get auto-calculated. The rest of the calculations shall remain the same.

Sample Workflow_v2.yxmd

Help

Accepted answers

BrandonB

I made one quick tweak to it just in case you have data that spans over multiple years. Updated workflow is attached:

Dynamic Calcs v2.yxwz

All comments

BrandonB

The trick to dynamic calculations is to avoid hard coded formulas that reference columns that have their names change. The way to address this in Alteryx is to use multi-row formulas and in your case, also a dynamic filter that brings in the date selected through the interface tool as well as the previous month. Screenshot is below and the analytic app example has been attached. Please let me know if you have any questions!

Dynamic Calcs.png

Dynamic Calcs.yxwz

BrandonB

I made one quick tweak to it just in case you have data that spans over multiple years. Updated workflow is attached:

Dynamic Calcs v2.yxwz

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335