Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
I want top 5 and bottom 5 customers. How to write the expression
Please help me
Thanks in Advance
Please find attached if fits your needs
There´s a function called FirstSortedValue that can do what you need
Bottom customers:
FirstSortedValue(Customer, Aggr(Sum(Sales),Customer),1)
FirstSortedValue(Customer, Aggr(Sum(Sales),Customer),2)
...
FirstSortedValue(Customer, Aggr(Sum(Sales),Customer),5)
Topcustomers:
FirstSortedValue(Customer, -Aggr(Sum(Sales),Customer),1)
FirstSortedValue(Customer, -Aggr(Sum(Sales),Customer),2)
...
FirstSortedValue(Customer, -Aggr(Sum(Sales),Customer),5)
Hi Abhi,
Please check my Firstsortedvalue Vs FirstValue Example
Hi Clever,
Its not working. I want to display top and bottom 5 customers in Bar chart.
Thanks in Advance
depending on what you are trying to accomplish, you may be able to use your standard expression and use Dimension limits tab
Sorry, if you need it inside a graphe please use Dimension Limits as akrepistman told
It would be easier if you post a sample of your application
Please find attached if fits your needs
Hi,
Try this