Restricting Zero Values in Chart

[#1]

Hello Gurus,

I need help into the below issue I am facing.

I have a chart wherein dimension - Customer is limited to Smallest 5. But chart is showing "No data to display" and found this is because there are 5 Customers with a zero value. If I uncheck "Suppress Zero Values" , it shows 5 Customers with Zero Values.

But I want to display lowest 5 customers with a non - zero value. How could this be acheived.

Thanks in Advance,

Sree

[#2]

Can you post a sample app?

[MK_QSL]

Dimensions

[Customer Name]

Expression

IF(SUM(Sales) > 0, SUM(Sales))

Sort

Y value ascending

Restrict by dimension limit to lowest 5.....

[MK_QSL · Accepted solution]

Another way is

Dimension

if(Aggr(Rank(IF(SUM(Sales) > 0, -SUM(Sales))),[Customer Name])<=5, [Customer Name])

Expression

SUM(Sales)

No need to restrict data...

[#5]

Hi Manish,

Thank you so much......that solved my problem !!

Below I have attached my solution in case someone else hits into this discussion with the same problem

Kindest Regards,

Sree

[MK_QSL]

Glad that my reply help you.