How to show bottom 10 business units and excluding zero values in Bar chart

[Anonymous]

Hi Guys,

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?

Thanks,

Russ

[sunny_talwar]

It might be easier if you are able to share a sample

Preparing examples for Upload - Reduction and Data Scrambling

[Anonymous]

So, this worked just needed a "-" before the "=" sign

[Anonymous]

Not sure if we can do this...do you have any other thoughts on the formula? -> even doing it with a simple [Revenue (dollars)] field?

[Anonymous]

This does not work when we filter by filter pane on certain selections....

Any thoughts?

[Anonymous]

Sunny - Going to repost this as the original solution did not work when filtering that the other community member suggested