I have a monthly report of work orders completed by IT. I serve 8 departments and only report on wo’s for 7 departments. (Select to exclude IT dept.) However, I would like a report line that shows the number of IT wo’s and the total number of wo’s for all departments including IT.

Example Report:
Dept 1 – 10
Dept 2 – 12
Dept 3 – 5
Total Non-IT wo’s – 27

IT WO’s - 13
Total WO’s – 40

If I have a Select for the report that states Departments not equal to IT, how can I show the totals?

I hope this makes sense. Thanks in advance for any assistance.


Edited by JWaldmann - 02 Feb 2017 at 9:22am

Thanks for the response! I do not know how to suppress one member of a group. IT is simply one of the departments.

Hey, once I picked the right @%*# Table, it worked great. Thanks a lot!

Can you assist with getting IT out of the chart at the top as well?

Thanks.

Morning Friend,

The Suppress worked so great! Thanks again.

I created the Formulas; however, the result was to put the IT bar first in the list and remove it's label. The bar is still there.