Calculations in crosstab question

[mortac8]

I'm generating a report off of my universe. I have a basic example shown
below. I need to be able to subtract Data2 - Data1 but I cannot because they are not aligned.
Is there any way I can get rid of the empty cells in my columns to align the data so I can subtract Data2-Data1 and store the result in another column? If not, is there any way I can perform the subtraction? Right now I just get -21, 60, -23, 59. I want to get 39 and 26. I need to eliminate the empty spaces!

Thanks a lot!

Date Data1 Data2
1/1 21
1/1 60
1/1 23
1/1
1/1
1/1 59

 

[BobWard]

your problem is that your cubes are not syncronized correctly. Look at your data providers and seehow the cubes are linked. Do both cubes have the same dimensions ? Are they linked correctly ?