Please help me with the below scenario
load * inline [
With in a straight table, display the products whose rank(sales) ranges between 3 to 7 by using
1. Set Analysis with p()
2. By using the rank() in the if loop or other
The products should be from rank3 to rank7.
I tried by using the rownum() in the if loop the data is sorting on basis of rownum(). But I need sort the data on the basis of rank of sales. Any suggestions please.
Solved! Go to Solution.
try this expression instead of going set analysis in expression tab
i tried this one its working and paste the below expression in sort tab also
=if(rank(Sales)>=3 and rank(Sales)<=7,sum(Sales))
=if(rank(Sales)>=3 and rank(Sales)<=7,rank(Sales))