Stacked Bar Max Visible Error

[#1]

Hi All,

I built a stacked bar graph and would like to show values for the top 10 categories while putting all the rest into an "Other" bucket.  When I selected Max Visible Number = 10 and checked Show Others on the Presentation tab, I got this as a result:

The crazy stacked blue bars are "Other" and definitely not correct.  The formula is set up as a contribution to growth formula:

(This year amount for category - last year amount for category)

/ Last year total amount

Has anyone come across this before?  Is there any solution?  I've tried using Aggr functions but maybe I'm not putting them in the correct spots.

Thanks,

Claire