Thank you for the post. However I don't believe I explained it properly.
I have attached a picture of the layout of my cross tab. you will see an empty cell that I would like to place my formula in.
My issue is that the column/row value I need is dynamic. The goal is to compare the total $ for Quarter 1 to Quarter 2 for a Year....and that year could be numerous years.
In crystal reports (sorry to reference that), there was an option to use the Previous value.
your example shows a static table and that is not what was asked. I need to do it in a crosstab as the years/qtrs are dynamic.