Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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