How to remove dimension who had null values?

[#1]

hi Experts,

I am trying to show 80 20 report for my customers.For that i have done one chart had customers as dimension and using expression as

if(  (Rangesum(above(count(bookings),1,rowno())) / count(total<bookings>bookings)) <=0.8,

count(bookings) ).

This gives values as 20% customers who are all giving 80% business. but my problem is the chart shows null values to other customers who are all not in the 20% customer.

can anyone give solution how remove this null values?

please see the image attached.

thanks in advance

[sunny_talwar]

Try checking 'Suppress When Null' on the presentation tab of the chart properties

[#3]

thanks for your reply,

i have tried but it won't work.

[Anonymous · Accepted solution]

Instead you can use Dimension Limits to show 20% or 80% customers. Thanks

[sunny_talwar]

Would you be able to share  a sample?

[#6]

thanks satayadev it works.