I'm having troubles trying to set up a pie chart, I hope I can explain this well enough.

I'm doing a chart with data (Customers Added), based on a date range (year).
The Data shows up the way I want however the problem is that I need a pie chart at the bottom showing the percentages of the total customers added each year (based on the params), but also adding the number(%) of customers NOT included by the parameters grouped together in the chart as well.

So what i have done is created a report that shows all the customers by year but suppresses those not included in the params, so that the pie chart will reflect all the customers but how do I attempt to group certain ones depending on a parameter value?  I see the Highlight option but it is dependent on set dates.

I'm guessing i have to put some kind of formula together, almost thinking that this entire pie chart needs to be in a sub report.

Can someone please point me in the right direction?  Any help is greatly appreciated!

so you want to show two slices, one inside your params and the other outside your params, correct? make a formula to identify each grouping

try this formula for including year data...

Edited by DBlank - 02 May 2011 at 5:53am