Unanswered: How do I create a formula in a cross-tab that uses a value from a previous column?
This is an extremelly simplified model of my environment, but should explain my problem.
I basically have the following fields in my table:
I want to create a cross-tab in Crystal Reports XI SP2 that has Employee as a row header (no problem), Year as a column header (no problem), and then, for every year, I want to see Sales and --here comes the problem-- the growth rate based on the previous year.
This is what my report should look like (and whether this looks fine or not will depend on the forum font):