Cross Tab formatting question

[stalukder]

Hello,

This may be a simple answer but is there a way to create a cross-tab that looks like the following...

# of Accts # of Shirts $ of Revenue
Rep1 10 15 $150.00
Rep2 5 10 $100.00

the # of accounts will have to be a distint count of the customer number due to the same customer number maybe order shirts on different lines.

Any help will be great. Right now, I build a formula for each cell and sum it to the report footer.

Thanks.

 

[lbass]

Not enough information here to respond. What fields are you working with? What does the data look like at the detail level? Please show a little sample with a few rows that illustrates the problem and show the expected summaries.

It would also help to see the content of your formulas.

-LB