Month to Month Analysis Report

[Gamaliel]

Hello,

Just want to ask how can I produce an output like this? I want to show the net amount in a specific day and month. for others which have no amounts/or net zero, they must also be presented. Please see the attached partial workflow.

Thank you.

[atcodedog05 · Accepted solution]

Hi @Gamaliel 

Here is how you can do it.

Workflow:

1. Taking Days and Months separately. Using append tool to create combination of days and months.

2. After summarize tool using join tool to join on days and months.

3. Using formula tool to convert months to months numbers. This will stimulate column sorting in order.

4. Using crosstab to convert month rows to columns.

5. Renaming month numbers to month names.

Optional 6. Using multi-field formula tool to add "-" for null. Note this will convert the fields to string type.

Hope this helps : )

[Gamaliel]

@atcodedog05 Thanks. I fully understand it.

[atcodedog05]

Happy to help : ) @Gamaliel