Dinamically organize columns

[Seba]

I need help on how to dynamically organize columns related to Date, but there always must be an extra column at the end for "YTD Total"

This workflow is design to reed all Trial Balances from a folder (qty of files in this folder increases every month) and generate a report with multiple sheets, some by Cost Center showing values by expenditure category by month plus the YTD Total.

The expected result would be like in image "Order ok"

The expected result for next month would be like in image "Order next month ok"

Instead every following month I run this workflow I get following result (Order next month NOT ok)

Any idea how I can get those columns dynamically organized?

Thanks!

[binuacs]

@Seba The workflow is not uploaded properly, the calendar macro and the input file, can you upload a simple input file and expected output for better understanding, 

[PangHC]

one of the simple ways is to move the "Dynamic or Unknown fields" above the "YTD total". 

just apply to the last select tool/table tool 

[Seba · Accepted solution]

I found a solution using a macro that generates the month columns I need for each report, and then I use the Union tool to join the transactions with the calendar table.