I'm using CR9 to create a drill down report that displays a pie chart showing tickets by department with a corresponding legend. However there are some tickets where the department wasn't selected. Those tickets are displayed in the legend without any department title. I would like to show in the legend all of these tickets as "no department selected" and place it at the end of the list. I would think I'd have to do this by using a specified group order. However if I go into chart expert, data, advanced and select on change of department and then go into order, specified order I can no longer drill down in my report. On the data, group button there isn't an option to select a specified order. Does anyone know of a way to do this?
Thanks
Thanks