I believe you are looking for "cross-tab" functionality in Crystal. I am using Crystal Reports Developer, Full version 126.96.36.1992 (I need to update to 11.5). The help file of Crystal using the Index Tab for "cross-tabs" has a good page of information an example of how data is displayed and summed up/aggregated both vertically and horizontally.
Best of Luck.
MCITP: DBA, MCSE, MCTS: SQL 2005, OCP