Multiple Values in One Cross Tab Column

[paddis]

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.

[kmalzewski · Accepted solution]

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.

[paddis]

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