Group certain incidents as one and rename in cross tab report
I have a simple cross tab display report which shows how many incidents are created by our agent during a certain time period.
I have filtered the report to only count certain types of incidents raised. I display the incidents.prod_id but some of the incidents.prod_id's i want to group and display and count as one.
What is the best way to do this?