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.