Hello,
i am trying to a pivot table in Alteryx and currently getting this output but want to see the output like on second table -
Current Output-
| AC | Serial | $$ | |
| 2345 | 56345 | 4,545.00 | |
| 2345 | 56360 | 11,362.50 | |
| 2345 | 31267 | 28,406.25 | |
| 2345 | 31549 | 71,015.63 | |
| 2345 | 34090 | 177,539.06 | |
| 2345 | 39718 | 443,847.66 | |
| 2345 | 39802 | 1,109,619.14 | |
| 2345 | 101032 | 2,774,047.85 | |
| 2345 | 111505 | 6,935,119.63 | |
| 2345 | [Null] | 11,555,502.71 | Total of 2345 |
| 7678 | 345346 | 567,567.00 | |
| 7678 | 56456 | 34,543,543.00 | |
| 7678 | [Null] | 35,111,110.00 | Total of 7678 |
| 3457 | 456546 | - | |
| 3457 | [Null] | - | |
| 3457 | 23143 | 34,534,655.00 | |
| 3457 | [Null] | 34,534,655.00 | Total of 3457 |
Expected Output -
| AC | Serial | $$ |
| 2345 | [Null] | 11,555,502.71 |
| | 56345 | 4,545.00 |
| | 56360 | 11,362.50 |
| | 31267 | 28,406.25 |
| | 31549 | 71,015.63 |
| | 34090 | 177,539.06 |
| | 39718 | 443,847.66 |
| | 39802 | 1,109,619.14 |
| | 101032 | 2,774,047.85 |
| | 111505 | 6,935,119.63 |
| | | |
| 7678 | [Null] | 35,111,110.00 |
| | 345346 | 567,567.00 |
| | 56456 | 34,543,543.00 |
| | | |
| 3457 | [Null] | 34,534,655.00 |
| | 456546 | - |
| | [Null] | - |
| | 23143 | 34,534,655.00 |
| Total | | 81,201,267.71 |
Thank you
Kauser
