Hi Everyone,
As I am still learning this new tool. Could you please help me how to perform this in Alteryx please? I currently have it done in excel but I couldnt convert it to Alteryx.
This is my current data output file.
| NSW | NSW1 | 10.00 |
| NSW | NSW2 | 20.00 |
| NSW | NSW3 | 30.00 |
| NSW | NSW4 | 40.00 |
| QLD | QLD1 | 50.00 |
| QLD | QLD2 | 60.00 |
| QLD | QLD3 | 70.00 |
But I would like to add sub total, grand total and some manual input number in to this output file and create a similar table like this one that I have in Excel.
I tried the sumarize tool but I would like to keep the column Cost Centre on the table.
if I need to add manual input fields in 3 columns like below, How do I add that to output file please?
Thanks so much in advance!
| State | Cost Centre | Amount 1 | Manual Input 1 | Amount 1 + Input 1 | Manual Input 2 | Manual Input 3 | New Amount | Rate | Payable Amount |
| NSW | NSW1 | 10.00 | | 10.00 | | | | | |
| | NSW2 | 20.00 | | 20.00 | | | | | |
| | NSW3 | 30.00 | | 30.00 | | | | | |
| | NSW4 | 40.00 | | 40.00 | | | | | |
| | NSW5 | | 50.00 | 50.00 | | | | | |
| NSW Total | | 100.00 | 50.00 | 150.00 | 200.00 | (50.00) | 300.00 | 5% | 15 |
| | | | | | | | | | |
| QLD | QLD1 | 50.00 | | 50.00 | | | | | |
| | QLD2 | 60.00 | | 60.00 | | | | | |
| | QLD3 | 70.00 | | 70.00 | | | | | |
| QLD Total | | 180.00 | - | 180.00 | 100.00 | (50.00) | 230.00 | 4% | 9.2 |
| | | | | | | | | | |
| Grand Total | | 280.00 | 50.00 | 330.00 | 300.00 | (100.00) | 530.00 | | 24.20 |
