Filtering a Section Total 1

[Newbie0]

Hi, I am trying to filter data out of a section total based on criteria from another field.

Center[tab]IT Associate[tab]Activity[tab]Jan[tab]Feb[tab] Mar[tab]Tot
452[tab]Greg[tab]Planning[tab]1[tab]1[tab]1[tab]3
Mary[tab]Coding[tab]5[tab]5[tab]5[tab]15
Jon[tab]Meeting[tab]2[tab]2[tab]2[tab]6
Section Total for Center 452[tab]8[tab]8[tab]8[tab]24
Section Total for Co. Employees[tab]?[tab]?[tab]?[tab]?

If Greg and Mary are company employees and Jon is a contract employee, how can I get the section total for just the company employees (another field indicates whether the person is an employee (0) or a contract employee(1)). Each column is its own field.

Thank you in advance for your help!

 

[bcbasslet]

whatever that indicator field might be called, say its called 'ETYPE'
then you'll
SUM your fields (whatever you're doing)
BY CENTER BY ETYPE NOPRINT BY EMPLOYEE BY ACTIVITY
ON ETYPE SUBTOTAL MULTILINES
ON CENTER SUBTOTAL MULTILINES
If you use SUB-TOTAL with a dash in the middle, you'll get subtotals on every single BY field..you might like it, you might hate it.

-SUSANNAH