Summing Detail

[briank]

I have a report outputs four detail rows - numbered 1-4. In my footer I have
sum and average rows which calculates the detailed section in an aggregate
fashion. Meaning it combined the data from Rows 1 - Row 4 in both a sum and
average. In addition to this I would like to show sum and averages on the
specific detail rows (Row 1, Row 2, Row 3 & Row 4). Perhaps I'm missing an
obvious fix here but I'm drawing a blank on how to do this.

 

[Duane Hookom]

Some sample records and desired display in a report would make this much
clearer. I'm not sure how you would sum a single row. Perhaps your
understanding of rows, detail, and aggregate don't match mine.

 

[briank]

Below is a sample of my report which shows a header (i.e. City) and detail
(Rows 1-4). It is the footer that is causing me problems. The sum and avg
is calculating based on the total numbers in the rows. I would my report to
include totals for the individual Rows in addition to the current sum and avg.

City 1
Row 1 10
Row 2 20
Row 3 40
Row 4 50

City 2
Row 1 15
Row 2 25
Row 3 45
Row 4 55

City 3
Row 1 11
Row 2 21
Row 3 41
Row 4 51

Footer

Row 1 36 (desired addition)
Row 2 65 (desired addition)
Row 3 126 (desired addition)
Row 4 156 (desired addition)

Sum 383
Avg 96

 

[Duane Hookom]

If I understand correctly, you are grouping by City but want to see
aggregate information in the report footer section across all cities. You
can do this by create a totals query similar to your report's record source.
Remove the City field from this query and group by Row values. You can use
this totals query as the Record Source of a subreport.

 

[briank]

Thanks for the direction Duane.

If I understand correctly, you are grouping by City but want to see
aggregate information in the report footer section across all cities. You
can do this by create a totals query similar to your report's record source.
Remove the City field from this query and group by Row values. You can use
this totals query as the Record Source of a subreport.