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.