How to view bottom 10 business units by revenue and excluding 0 values in bar chart
I am struggling with displaying the bottom 10 Product Lines and excluding the zero values (the data that was not input yet). When I check do not show zero values then I do a limitation on a fixed number of bottom 10, I get no data to display.
I think this is because it is trying to pull the zero data units in and there are none. How do I exclude the business units that have 0 in for revenue and display only the bottom 10 that actually have a number in there?
We had a fix for the overall view, which was to type in: