Dec 2024 & Jan 2025 - Calculate the Difference

[PassION_es]

Hello Alteryx,

This is in reference to https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Movement-Difference-by-Month/m....

I want to request your assistance to change the logic.

Since January 2025 is the last reporting month, I would like to compare it against the December 2024 movement. 

If possible, I would like the workflow to position December 2024 and January 2025 close to each other in the spreadsheet.  Otherwise, ensure the difference is calculated, even if the columns are arranged sequentially by month name.

Thank you.

[PassION_es]

Attached is the dummy input and output tabs.

[alexnajm · Accepted solution]

I can't see your attachment due to the Community still going through a virus scan, but you can Transpose your data and Crosstab it back which will put the column you select as a Header in alphabetical order! 

[PassION_es]

Thanks @alexnajm