2 Replies Latest reply on Jul 24, 2013 10:11 PM by SriniVEERAVALLI

    Can i Display top 100 and bottom 100 sales on same report Using different views


      Hi GUYS,



          I have a question....How to display top 100 sales and bottom 100 sales in same report. But using 2 view for displaying top 100 and bottom 100 sales.


          I created a rank measure for top 100.

          its working fine...

        for Bottom 100 is always a problem. I use BOTTOMN function to get the bottom 100. But creating a Rank for Bottom 100 is a problem..

      Still the sorting order is a problem..




      Thanks in Advance