Greetings,
I have a few tables that keep track of how much business is coming from each client. I have a query set up which counts the number of jobs each client has given year to date.
My problem is this: I have about 50 clients I would like to display on a report (particularly on a pie chart with percentages). Since this number would be too many to show on a single pie chart I want to display the top 5 producers with their percentage of jobs and the rest to be grouped and displayed as "Other" on the pie chart. Is this possible?
I have a few tables that keep track of how much business is coming from each client. I have a query set up which counts the number of jobs each client has given year to date.
My problem is this: I have about 50 clients I would like to display on a report (particularly on a pie chart with percentages). Since this number would be too many to show on a single pie chart I want to display the top 5 producers with their percentage of jobs and the rest to be grouped and displayed as "Other" on the pie chart. Is this possible?