Help with Subtotal

[abc567]

Now i am onto different report.

Its based on grouping too.

Group 1 is based on ReqType column
Group 2 is based on WorkOrderType column


Group 1 Data - Physical and Claim

Group 2 Data - New and Old


Avg Survey TIme= Sum(Survey Time) / Count(Work orders)



Avg Survey Time
PHYSICAL
New 1.2
Old 1.7

PHYSICAL SubTOTAL ? ? ?


CLAIM
New 2.3
Old 7.1

CLAIM SubTOTAL ? ? ?


Grand Total 12.3 ( I calculated this using lbass's method- Its working fine)



I need help with calculating subtotals.

"Insert Summary" is not considering this formula.


Thanks

 

[lbass]

Please show the actual formula for avg survey time. Nobody (including me) will know what you mean by "lbass's method," since I don't have one particular method--a method is driven by the particular problem. I also have helped you on a number of posts, so please spell out the method if it is relevant to the current problem.

-LB