2 Replies Latest reply: Jul 24, 2013 5:11 PM by Srini VEERAVALLI RSS

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

    983230

      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

      Reddy.