I am struggling with displaying the bottom 10 business units 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?
A sample of what exactly?
When I select bottom 10, I see the bottom 10 that are all zero $. I need to exclude those and get to the bottom 10 that actually have data.
If I select exclude zeros, nothing shows up at all.
Thanks for your reply...Where would I place this set analysis? In the overall expression or in the limitation expression? Thanks Sunny