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!
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!