Add / SUM from dates on spreadsheet from months Jan thru December

I want to Add / SUM from dates on a spreadsheet from months Jan thru December, but only the last 6 months.

So I run a report every month for the last 6 months and I have to change it manually each month and enter the new month in and remove the last one.

How can I have it just add whatever month is in my date range?

Any help is appreciated my friends!

Regards,

JohnnyF

Tech Batch Usage Lessen.yxzp

Tech Batch Usage Lessen.yxmd

Preparation

Accepted answers

I hope you don't mind, but I rebuilt the back half of your workflow to this:

I'm using some Dynamic Select and Multi-Field Formula tools to help speed up and optimize your workflow. This will now always grab the last 6 columns in the dataset and create a Sum and Average column. I am also utilizing a Dynamic Rename tool to update the column names that prevents the Date columns from not being in chronological order.

Output looks like this:

I've attached a packaged workflow for you to try out.

Let me know if this helps.

Cheers!

Phil

Tech Batch Usage Lessen - Dynamic Solution.yxzp

All comments

if i were you, i'd use the "DateTime Parse" tool to change the "Inventory Txns Date" field into a datetime field instead of text

once you have that, then you can just filter for the previous 6 months

[Inventory Txns Date] >= DateTimeAdd(DateTimeToday(),-6,'months')

💡

My man! I might give that a try.

Thanks, Matt.

I hope you don't mind, but I rebuilt the back half of your workflow to this:

I'm using some Dynamic Select and Multi-Field Formula tools to help speed up and optimize your workflow. This will now always grab the last 6 columns in the dataset and create a Sum and Average column. I am also utilizing a Dynamic Rename tool to update the column names that prevents the Date columns from not being in chronological order.

Output looks like this:

I've attached a packaged workflow for you to try out.

Let me know if this helps.

Cheers!

Phil

Tech Batch Usage Lessen - Dynamic Solution.yxzp

Wow @Maskell_Rascal , Really appreciate it!

Hope one day I become an Alteryx master!

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703