We are facing an issues as we are having list of 50 products and 50 DBM from which we have to show top 10 product and top 10 DBM and the remaining should come in ‘REST’ . So by using rank function we are Showing top 10 Products / DBM and remaining in ‘REST’ as shown below . Now the issue is ‘REST’ should be always placed at the bottom while sorting in descending order in Product as well as DBM even if ‘REST ’ has high value . Sorting is based on CY (Current Year) .
Hope this resolve your issue. If the issue is solved please mark the answer with Accept as Solution & like it. If you want to go quickly, go alone. If you want to go far, go together.
