Hello to everyone.
I´m working in a workflow that shows all the month in the database, something similar to this.
Now, consider that the workflow is showing all the month except for today (June)
but I need to sort the last month (descending) and it has to be dynamic, today the month is may, but next month will be June and so on.
Thank you.
Solved! Go to Solution.
Hi @neromerob
Attached is a workflow!
What I did here is created a record ID to maintain the rows, then pivoted the data to create month numbers, after that i sorted in ascending order and pivoted it back!
If this solution solved your problem, please mark it as a solution!
Thanks
Hey @neromerob,
Here is an simple dynamic workflow which can do this:
Any questions or issues please ask :)
HTH!
Ira
Sorry to everyone I was ill and couldn't test the solutions properly until today.
I think i need another approach.
you see, originally the date in the database is presented like this. (just and example)
This means that "DATE" is how originally the date is presented and "month" is how I extract the data to do later any transformations that i requiered ("Sep-2022"; "September-2022)
This means that any change that i must do to get until the previous month should be done before the formula. could be adding a new file or any other solution. any thoughts.
Thank you.
Hi @neromerob!
I think we might need more details. A sample of the input and desired output would help.
If your data looks like the screenshot above, will a filter on the DATE field work?
Hello to everyone.
I´m adding a workflow that more or less show what I need.
In here you can see a database with 4 months (From March to June), June is the last moth but I need to show information until the previous month (from March to May) sort by the last month descending.
Keep in mind that month will change eventually and the information shown should reflect that change.
I add a normal sort tool just to show you how the information looks like this month.
Thank you again
Hi there,
I attached a workbook. This is adding onto the process I sent earlier. I created a macro for this and fed in the latest month field in the macro to automatically update the sort.
If this solved your problem, please make sure to mark it as a solution.
Thanks!