topic Dynamic layout of months in Alteryx Designer Desktop Discussions

Dynamic layout of months

Carlyn — Fri, 23 Jan 2026 12:20:27 GMT

Hi,

I am building a workflow where the output includes a sheet in excel that shows the overall total for each business unit and then the values per month. In the attached workflow you can see that the first flow is using data Jan25 - Dec25 and then anything +365 and it outputs with Dec25 being the first column and +365 being the last. This is the way it should display.

The second flow is using the same tools and the data is Jan25 - Mar25 and despite the other months not being in the input it still displays with Mar25 being the first column and Jan25 being the last.

The issue I have can be seen in the third workflow, when the data in the input is now pulling in Jan26-Mar26, I am wanting Mar26 to be the first column and +365 being the last.

Is there a way to set this up dynamically so that it outputs in the right order?

Its not allowing me to attached the workflow so I will try to do this in the comments.

Re: Dynamic layout of months

Carlyn — Fri, 23 Jan 2026 12:20:54 GMT

Workflow attached

Re: Dynamic layout of months

caltang — Fri, 23 Jan 2026 12:42:18 GMT

Like so?

Re: Dynamic layout of months

Carlyn — Fri, 23 Jan 2026 14:07:12 GMT

Hi Calvin

Thanks for responding.

I am trying to make it so that the most recent month always appears as the first column after the total column, so in this case it would be BU, Total Value then Mar-26 like this:

Re: Dynamic layout of months

Carlyn — Fri, 23 Jan 2026 14:08:58 GMT

Ah, I just changed the sort at the beginning of your workflow to descending and it now works.

Thanks again!

Re: Dynamic layout of months

caltang — Fri, 23 Jan 2026 14:11:09 GMT

That's easy, just change the sort to Descending here: