Dynamic sort descending by last month

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.

Workflow

Output

Help

In Database

In-Database

Accepted answers

CarliE

@neromerob ,

I submitted a solution ~20 minutes ago, let me know if that solved your problem

All comments

CarliE

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

Dynamic sort descending by last month.yxmd

IraWatt

Hey @neromerob,

Here is an simple dynamic workflow which can do this:

Any questions or issues please ask
HTH!
Ira

Workflow0506.yxmd

csmith11

Sorted on the last column in Descending order:

Show information from previous month.yxmd

binu_acs

@neromerob one way of doing this with the Dynamic Select tool

DynamicSort_09_06.yxmd

ddiesel

Hi @neromerob!

Kindly let us know if any of these solution(s) worked for you.

Thanks,
Deb

neromerob

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.

binu_acs

@neromerob Can you attach the sample input file as well?

CarliE

@neromerob ,

I submitted a solution ~20 minutes ago, let me know if that solved your problem

Quick Links

This months top contributors

hhaigh1 280

FláviaB 262

JORGE4900 235

caltang 177

DanM 167