Hi,
Greetings !
I have dummy input template which shown the number of new and resigned staff for this year.
| Department | Jan | Feb | Mar | Apr | Jan (-) | Feb (-) | Mar (-) | Apr (-) |
| Finance | 4 | 0 | 4 | 1 | 1 | 0 | 0 | 1 |
| IT | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 |
| HR | 2 | 1 | 0 | 0 | 0 | 1 | 0 | 1 |
| Legal | 1 | 2 | 0 | 0 | 2 | 0 | 0 | 0 |
I require to add new 'total' columns for each group and 'differences' column, so the output should be as below :
| Department | Jan | Feb | Mar | Apr | Total New Staff | Jan (-) | Feb (-) | Mar (-) | Apr (-) | Total Resigned Staff | Differences |
| Finance | 4 | 0 | 4 | 1 | 9 | 1 | 0 | 0 | 1 | 2 | 7 |
| IT | 1 | 0 | 1 | 1 | 3 | 0 | 0 | 0 | 0 | 0 | 3 |
| HR | 2 | 1 | 0 | 0 | 3 | 0 | 0 | 2 | 1 | 3 | 0 |
| Legal | 1 | 2 | 0 | 0 | 3 | 2 | 0 | 0 | 0 | 2 | 1 |
Currently i only used Formula tool to calculate and Select tool to reorder the sequence.
However, the issue come in after the next month being added, for example May, the result will be as below ( which is wrong order ) :
| Department | Jan | Feb | Mar | Apr | Total New Staff | Jan (-) | Feb (-) | Mar (-) | Apr (-) | Total Resigned Staff | Differences | May | May (-) |
| Finance | 4 | 0 | 4 | 1 | 10 | 1 | 0 | 0 | 1 | 2 | 8 | 1 | 0 |
| IT | 1 | 0 | 1 | 1 | 3 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 0 |
| HR | 2 | 1 | 0 | 0 | 5 | 0 | 0 | 2 | 1 | 3 | 2 | 2 | 0 |
| Legal | 1 | 2 | 0 | 0 | 3 | 2 | 0 | 0 | 0 | 2 | 1 | 0 | 0 |
I think the issue come from Select tool since May is new column added in the input file
Please advice is that possible to create fixed columns sequence.
Thank you in advance !
