Skip to Content
0
Former Member
Jan 29, 2008 at 04:36 PM

Getting database totals under a second group

10 Views

Post Author: mmishkin

CA Forum: Formula

I have a report broken out by doctor, and then procedure. I want to have totals by procedure (for the whole data set) but it keeps breaking it out by the first group. I've tried many different ways but it always comes up as the database total being the same as the doctor total. Any ideas??

Doctor (group 1)

Procedure (Group 2)

Total By doctor

Database Total

Difference

Dr Smith

Hip

12

?

?

Stomach

52

?

?