We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

change month order

Ar13f
10 - Fireball

Please assist me; I'm trying to create a report similar to the one below, but the outcome isn't what I'm looking for:

 

P1.png

 

 

 

 

 

I'm looking for the following result, I want the header for the month as below:

 

P2.png

 

please help and advice, I have attached it to the workflow.

11 REPLIES 11
Ar13f
10 - Fireball

Dear @atcodedog05 

 

thank you very much for your advice and help ... it seems I really have to learn a lot in this community especially for regex functions (reply message from @cmcclellan) and formulas like this "DateTimeFormat(DateTimeParse([_CurrentField_],"%Y_%m_%d"),"%b-%Y")"

 

 

 

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @Ar13f 

Cheers and have a nice day!

Labels
Top Solution Authors