1 Reply Latest reply on Jun 15, 2016 1:31 PM by Patrick A Van Der Hyde

    Sort order in Table Calculations

    Vishruth Reddy

      Hi Guys,

       

      Assuming we have 1 or more fields in each of the Partitioning and Addressing columns while using the 'Running along' as Advanced. Also lets assume that the sort order is set to ascending on a Measure.

       

      My question is should the sort order result in values

      1. Different for each partition or
      2. Sum up all the partitions and give a universal sort order for all the partitions?

       

      Attaching a workbook for reference with explanations.

       

      Thanks,

      Vishruth

        • 1. Re: Sort order in Table Calculations
          Patrick A Van Der Hyde

          Hello Vishruth

          On the tab "The Actual sort order" the Addressing for Index() is inclusive of all Dimensions in the view so the Index is overall.  The Sort is applied overall, ascending and therefore starts from smallest to highest sales value across all of the values in the view.  Without the restart per Region the setup that you have defined will include all Regions. 

           

          I suggest also reviewing the table calculations with the Beta version of 10.0 or with the new version when it is released because the new Table Calculation interface does a nice job of highlighting the measures involved.  In version 10, the configuration of the same table calculation is easier to see as changes are made.

           

          Patrick