Alteryx Designer

Find answers, ask questions, and share expertise about Alteryx Designer.
Andy Uttley, Alteryx ACE, makes music with Alteryx | Math + Music
SOLVED

Multiple Values in One Cross Tab Column

Highlighted
6 - Meteoroid

I am able to get a Cross Tab result with certain values (Ticket Count & Fare Amount) under a column sorted by Sales Source Type (ARC, BSP & DIRECT) where each value type is in its own separate Cross Tab result. I would like to have both values (Ticket Count & Fare Amount) under the same column for each Sales Source Type in one result. Attached is an example of the result I can get (two Cross Tabs) and the result I'd like to get.

Highlighted
5 - Atom

Have you tried a join on the yearmonth column? This will give you the ability to put the rest of the columns side by side, by month.

Capture.PNG

 

 

Highlighted
6 - Meteoroid

That works great. Certainly close enough. Thanks, kmalzewski!

Labels