Crosstab - Calculated fields

[mtl2302]

CRXI

Is there a way to insert calculated fields in to a crosstab report? I have two column levels. The top level is a product summary: A, B, C. Within each product summary there are various products, which is the second column level.

I'd like to be able to calculate the total of B sold as a percentage of A+B. I'd also like to calculate C as a percantage of the Grand Total of products sold.

I'm thinking of creating formulas to calcuate, but can't figure what fields to add,divide, etc. since I'm trying to calculate totals. I don't see any summary fields in the formula editor like you would in a regular Crystal Report. Also where would you drop the fields in to the crosstab, or would you have to be creative, and enter and then suppress?

 

[Madawc]

A crosstab is based on individual records. Anything that involves comparison of two or more records can't be used for a crosstab.



Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[lbass]

That's not actually true; you can do comparisons within crosstabs. Please identify your row, column, and summary fields, using field names.

-LB

 

[mtl2302]

Row: Salesperson
Column 1: High level product summary group broken into A,B,and C.
Column 2: Detail level product (individual products)
Summary: Qty of sales

Again, I'd like to add some calculations as columns. So for each sales person I'd like to calculate summary group B as a percent of A+B and group C as a percent of A+B+C.

Thanks for your help.

ML

 

[lbass]

I don't have time right now to explain this in detail, but try to adapt the solution in thread149-1356319.

-LB