Cross-tab

[megias]

Hello,
I have a big problem. I have a cross-tab with 2 columns (each one is a year). I need to divide the second one over the first one.
example: Sales
item 2000 2001 2001/2000
01160000 25 30 1.2
01120000 40 30 0.75

I need to get the value of column (2001/2000)

Any idea?

thanks a lot

 

[John43]

Try creating a formula, then add it to
your cross tab report.

 

[chelseatech]

A crosstab isn't the best solution for this sort of report. Create conditional formulas and summaries for both columns and then the third is just another formula. Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm

 

[kenhamady]

You will need to create a 'manual' cross-tab, because you can't write formulas that refer to cross-tab cells. Manual cross-tabs are described in faq149-243, which shows Common formula examples. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com