Using a Crossjoin in Crystal Reports

Question

Hello, I've got a problem with trying to translate a dataset into a more useable format. I have one that is currently outputting fields such as this.

PersonID    Year Sales
A          1    5000 
A          2    2000 
A          3    3000 
B          1    5000 
B          2    600 
B          3    200 
n..

I would like to translate it in a crystal report so that it outputs fields like this

Person  Year 1 Sales Year 2 Sales Year 3 Sales
A        5000          2000            3000
B        5000          600             200
n..

I would use a cross tab table, but I still need to be able to manipulate the results in the various yearxsales fields. Can anyone help me with how I can do this with crystal?