Filtering a Section Total
Filtering a Section Total
(OP)
Hi, I am trying to filter data out of a section total based on criteria from another field.
Center IT Associate Activity Jan Feb Mar Tot
452 Greg Planning 1 1 1 3
Mary Coding 5 5 5 15
Jon Meeting 2 2 2 6
Section Total for Center 452 8 8 8 24
Section Total for Co. Employees ? ? ? ?
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!
Center IT Associate Activity Jan Feb Mar Tot
452 Greg Planning 1 1 1 3
Mary Coding 5 5 5 15
Jon Meeting 2 2 2 6
Section Total for Center 452 8 8 8 24
Section Total for Co. Employees ? ? ? ?
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!
Talk To Other Members
RE: Filtering a Section Total
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