We are making a stacked area chart but only want zero items and everything summed as OTHER. The best we can do is top 1 chart, sum as other, and make lower values the top-n direction. While the second series is minimal, it shows up on the legend even when legend is set to 1.
Neither of these options can be set to zero.
This is result is mostly acceptable, but the table of data is still 'wrong' as the smallest item is not counted in the OTHER total. and the legend still says "... more series..."
Does someone have a 'more better' way to do this such that everything ends up in one OTHER or TOTAL type metric?
I was thinking to suggest you use the Formulas to obtain the 'OTHER' as sum of the metrics of interest and then plot it as area chart.
Does it apply to your case?