Custom Reporting - Multiple Ranges for Dept IDs
Our DPW Department encompasses a multitude of Department IDs. We would like to generate ONE report and save it to be refreshed with updated data.
For example: We currently run a report for dept 5110, export that to Excel; run another report for 8160 export to excel, etc. Then copy/paste each department to the original report so that we have a conglomerate of departments that encompass DPW.
Conversely, we could just put in a range capturing all of DPWs departments and then delete data that we don't need out of Excel, but again, it flies in the face of having a 'custom report'.
At least FIVE ranges in total requested. Thank you.