6 Replies Latest reply: May 22, 2014 6:51 AM by Sunil Chauhan RSS

    Sorting Help????

    Amit Saini

      Hi Folks,

       

      I'm having Pivot table as below:

       

      Is there any possibility of sorting order according to your choice .Please see below i want Un Bold labels to come in this order:

       

       

       

      Thanks,

      AS

        • Re: Sorting Help????
          Liron Baram

          hi

          if i understand the image

          sum of the fields are vertical dimensions label , and some are values in a horizontal dimension

           

          if this is the case as far as i know you can't order them as you want, those are diffrent types of columns

            • Re: Sorting Help????
              Amit Saini

              Liron,

               

              All these labels are under one calculated Dimension named as Downtime-Cat-Desc. Instead of vertical view i made them as Horizontal view. I just want to change order of these labels , if possible in the same view as mentioned in First image.

               

              For example after Downtime-Cat-Desc. , I want to see first Maschinenstorung  instead of Anfahren\Abfahren as first view if possible , vertical view should remain the same.


              Only order will change after Downtime-Cat-Desc as below :



               

              Thanks,

              AS

                • Re: Sorting Help????
                  Liron Baram

                  if this is the case then yes

                   

                  you could load an inline table

                   

                  somthing like :

                  Downtime-Cat-Desc, sortorder

                  fiedvalue     ,1

                  fieldvalue,2

                  that holds the sort number for each value

                  and in the sort tab you sort by expression and in the expression you write

                  = sortorder

              • Re: Sorting Help????
                Satish Kurra

                Hi

                 

                Please find the below example.

                 

                Hi

                 

                Please follow the below order of script for CUSTOM SORT.

                 

                Temp:

                LOAD * Inline [

                Category

                Meat

                Fish

                Chicken

                ];

                 

                Data:

                LOAD * INLINE [

                 

                Category,Sales

                Fish,100

                Meat,200

                Chicken,450

                ];

                 

                DROP Table Temp;

                 

                Note:

                Reload the script. Modify the properties of the Category list box and on the Sort tab,

                set the Sort by option to Load Order.

                • Re: Sorting Help????
                  Mohammed Mukram

                  Dear,

                   

                   

                  if you want to sort by your choice then create a Inline table.

                   

                  kindly find the attached document.

                   

                   

                   

                  Thanks,

                  Mukram.

                  • Re: Sorting Help????
                    Sunil Chauhan

                    use in sort expression

                     

                    wildmatch(fieldname,'value1yowwant','Valu2youwant','value3youwant',........)

                     

                    you can as many as ValueNyou want in above expression

                     

                    and try ascending or descending as you want

                     

                     

                    hope this helps