Results 1 to 1 of 1
  1. #1
    Join Date
    Jul 2004

    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:

    Year (numeric)
    Employee (text)
    Sales (numeric)
    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):

                2004             2005             2006
            Sales   Growth   Sales   Growth   Sales   Growth
    John      100      N/A     150      50%     100     -33%
    Susan     200      N/A     200       0%
    In this example, no Growth is shown in the first year, as there is nothing to compare to (it would be ideal if I could hide the Growh column altogether) and Susan was no longer an employee in 2006.

    Any feedback would be greatly appreciated.

    Thanks in advance!
    Last edited by Razor1973; 07-06-06 at 11:37.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts