Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have 5 expressions,i want to show that 5 expressions in one chart by using cyclic or anything but 4 expressions should be largest 5 values and remaining 1 expression should be smallest 5 values.can any one explain the logic for this?? please do the needful..
Thanks & Regards,
Ramakrishna
Change your expressions to return the correct 5 values. You can use the rank function for this. Something like if(rank(sum(Value))<=5, sum(Value)) for the top 5 and for the bottom 5 if(rank(-sum(Value))<=5, sum(Value))
Hi Gysbert,
Thanks for the reply,
Best Regards,
Ramakrishna