Sub-total problem

  • Thread starter Thread starter Pam
  • Start date Start date
P

Pam

I have a report with Detail info as follows, grouped by
Cost Center:
COST CENTER 06273
Asset Name Asset# Oper. Date Job# PlanTime Plan$
OM-4 Lathe 00506 20040902 EH0101 1.0 $32.90
OM-4 Lathe 00506 20040903 EH0101 1.0 $32.90
OM-4 Lathe 00506 20040912 EH0101 1.0 $32.90
OM-4 Lathe 00506 20040901 EJ0200 2.5 $98.12
OM-4 Lathe 00506 20040915 EJ0200 2.5 $98.12

Totals 8.0 $294.94

I do not want the totals for Cost Center to total
completely for all detailed entries. What I want to do
is to total ONCE for each job# because the PlanTime will
always be the same and is the total amount of PlanTime
for the entire job#. I want the totals to be the 3.5 and
$131.02, where is picks just once for EH0101 (1.0 and
32.90) and just once for EJ0200 (2.5 and 98.12) and
totals those numbers.

Any help on how to do this?? Thanks in advance!
 
I have made a grouping under Job# and in the footer
section of this group I have put the control source for
PlanTime and named it PTime and then the same for Plan$
and named it PDollars. But it will not SUM these new
names, Ptime and PDollars, in the next footer for Cost
Center. Under the Cost Center footer is where I want the
total to be listed. The numbers are putting out
correctly for the new grouping, but I cannot get a total
still. Appreciate any help.
 
Pam.
What you need to put in the Job# footer is the same as
what you put in the cost center footer.
so if you out in =Sum([Plantime]) and Sum([Plan$]) in
either or both of the footers it will work the same for
the appropriate footer.
Hope this helps.
Fons
 
Back
Top