Remove Others From Bar Chart

[Anonymous]

I have a top 10 bar chart that has "Others" as a bar.  I was wondering how I can get rid of the "Others" from the bar chart.  Will this be a set expression? I tried an If as well.

=if(BILLING_PROV_NM_WID <> 'Others',BILLING_PROV_NM_WID, '-')

[Chanty4u · Accepted solution]

dimension limit tab

un tick show others option

[Chanty4u]

uncheck this option

[Digvijay_Singh]

Hi,

Check if you have this clicked in your dimension limit tab -