2 Replies Latest reply on Aug 5, 2018 10:24 PM by Vijay Kulkarni

    Alternative to manual sorting

    RangaWal

      I have multiple fields, of which "not assigned" is a possible value.  When creating a frequency chart of each field, I would like "not assigned" to be at the top.  Is there a way to do this with a calculation, to avoid using manual sorting?

       

      Perhaps the easiest way is to create an alias with a leading space and sort alphabetically, but that's cheating

        • 1. Re: Alternative to manual sorting
          Naveen B

          Hi RangaWal,

           

          Click on the field --> Default Properties --> Sort --> Move the not assigned to top

          So whenever you uses the field since its default property not assigned will come @top

           

          Hope this helps kindly mark this answer as correct or helpful to close the thread and as well it will be helpful who are looking for the same solution

          BR,

          NB

          • 2. Re: Alternative to manual sorting
            Vijay Kulkarni

            Hi RangaWal,

             

            Please go through attached workbook. Create a set on dimension Assignment as Not Assigned based on value 'Not Assigned'. Drag it on row shelf before Assignment, right click on it and unselect Show Header option. This will help to show Not Assigned always on top. Also, it will provide flexibility to sort other members of Assignment field in Ascending / Descending or alphabetic order.

             

            Hope it helps you.

            1 of 1 people found this helpful