3 Replies Latest reply on May 17, 2018 3:30 AM by Ashwath Raj

    Displaying Rank even after filtering

    Ashwath Raj



      I have a scenario where i have used a combined set to show both TOP and BOTTOM N sub categories based on Sales. Based on index i have i am displaying the rank of each sub category. there are 17 sub categories, Now if i give input as show TOP  3 and bottom 3 i get the rank of the lowest sub category as 6, While it actually is 17 when displaying all the sub categories..


      The calculation1 column shows the index. Rank of rANK is the rank after filtering based on TOP AND BOTTOM N. I want to display the actual rank, irrespective of the rank after filteringrank.PNG