Hello, this is my first post on these boards and I'm just learning Alteryx so...go easy on me, guys. I'm using the Crosstab function to shift up to 8 account numbers from displaying in Rows to displaying as Columns, with the value for each account shown in the row under the account number. I'm then adding each of these totals by line to get a P.O. total.
Example:
P.O. Acct Total
1 55 $5
1 66 $5
1 77 $5
Should show as
P.O. Acct. 55 Acct. 66 Acct. 77 Total
1 $5 $5 $5 $15
But if one of those accounts had no activity, I'd get this
P.O. -Null- Acct. 66 Acct. 77 Total
1 $5 $5 $10
The math is still correct, but I'd like to have all the possible accounts listed as column headers, even if they have no activity. I tried playing around with Text Input or Input Data (using a Dynamic Rename) but couldn't figure it out. Anyone have any ideas? Thanks guys!
Bren
