0 Replies Latest reply: Aug 10, 2011 5:24 PM by chenders RSS

    Stacked Bar Max Visible Error

      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:

      Other Error.png

       

      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