Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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...
Can you post a sample app?
Dimensions
[Customer Name]
Expression
IF(SUM(Sales) > 0, SUM(Sales))
Sort
Y value ascending
Restrict by dimension limit to lowest 5.....
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...
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
Glad that my reply help you.