2 Replies Latest reply on Dec 2, 2018 8:14 PM by Tushar More

    Can someone help me in sorting the data

    Ranjan K T

      Hi Team,


      Can some one help me to sort the data by Descending order.

      I am not sure is there anyway to get this sorted.


      Below is the screenshot. I wanted to sort the last column which is "Total value of Potential sale".





        • 1. Re: Can someone help me in sorting the data
          Paul Wachtler

          Hi Ranjan,


          The issue you're going to have it that some of your Prospect Client Name values have more than one "Total value of Potential sale" values.  You can sort Prospect Client Name by "Total value of Potential sale" but where there is more than one value, it's going to sum them.  If you want to sort by each individual "Total value of Potential sale" value, then bring a copy of that field to the very front of your row column - to the left of Prospect Client Name.  Sort it in descending order, and right click on the field, and click "Show Header" to hide it.  Now your data will be sorted how you're asking.


          Let me know if you have any questions.



          • 2. Re: Can someone help me in sorting the data
            Tushar  More

            Hi Ranjan,


            In addition to input provided by Paul, here is my approach. You can create a calculation using rank like below:


            Replace Sales by your actual measure and convert it to discrete.


            Place it in the view and hide header.



            Workbook is attached for your reference.



            1 of 1 people found this helpful