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.