Complicated summing in a report

[Jon Rowlan]

I have a crosstab table that produces Sales Stats for each customer over a
number of years listing the sales for each period across the page.

This works very well and I can produce totals at the bottom of the report.

However, the customer wants to see totals in much the same way as they are
printed for each customer, one grand total for each year for each month.

customer ABC

Jan Feb Mar Apr
2001 10 20 10 40
2002 15 16 20 16
2003 16 17 10 20

Customer
Totals 99 99 99 99

Grand Totals

2001 999 999 999 999
2002 999 999 999 999
2003 999 999 999 999

Is this possible? Perhaps with "Running Sum" ?

To me it seems an unreasonable request .... should really be a different
report ....

Any ideas anyone ?

thanks all,

jON

 

[John Spencer]

You are correct, it is a different report.

Build it as a different report and then use your summary report as a
SUB-report in the report footer (or some other group section) in your
original report.

 

[Jon Rowlan]

perfect Thanks John.

I will give it a go.

jON

You are correct, it is a different report.

Build it as a different report and then use your summary report as a
SUB-report in the report footer (or some other group section) in your
original report.