In a chart I have to count cases by a special information called "priority", I have 11 differents priorities but the chart only have to show 5 of the them in 5 different columns dinamically, and the rest of the count cases with differents priorities must be displayed in a sigle column called "other".
I'm using a Report Definition to filter only the 5 priorities that I need. What should I do to put all other priorities into "other" column in the chart?.
One way to do this would be to implement a SQL function alias (e.g., "Other") that would return false/zero for the 5 specific priorities you are pulling out, and true/one for all others. You could then add a column to your report with a count of "Other" cases.