6 Replies Latest reply: Oct 4, 2017 4:00 PM by Joshua Russin RSS

    Pivot Table sorting help

    Joshua Russin

      Hey everyone,

       

      I have these 'types' of data.

      2017-10-04_12-41-13.jpg

      I am trying to sort this data into a few different groups within a different pivot table, kind of like this.

      2017-10-04_12-53-56.jpg

      Except I also want to add a 4th group called 'Total' that has all of the 'Types'

       

      This is how I was trying. Any help or suggestions?

       

      =if(WildMatch(SaTy_OTIF,'2MEM','2MMO','NB2','ZBPU','ZD2S','ZKR'),'Internal / Warehouse to Warehouse',

            if(WildMatch(SaTy_OTIF,'ZEU1','ZIN1'),'OUS',

            if(WildMatch(SaTy_OTIF,'OR','UB'),'Domestic',

            if(WildMatch(SaTy_OTIF,'2MEM','2MMO','NB2','ZBPU','ZD2S','ZKR','ZEU1','ZIN1','OR','UB'),'test'))))

        • Re: Pivot Table sorting help
          Sunny Talwar

          May be enable the total?

           

          Capture.PNG

          • Re: Pivot Table sorting help
            Felip Drechsler

            Hi Joshua,

             

            Create another field with the expressions your using, something like:


            Table:

            Load

                 SaTy_OTIF,

                 // Other fields here,

                 if

                 (

                      WildMatch(SaTy_OTIF,'2MEM','2MMO','NB2','ZBPU','ZD2S','ZKR'),'Internal / Warehouse to Warehouse',

                       if

                      (

                           WildMatch(SaTy_OTIF,'ZEU1','ZIN1'),'OUS',

                            if

                           (

                                WildMatch(SaTy_OTIF,'OR','UB'),'Domestic',

                                 if

                                 (

                                         WildMatch(SaTy_OTIF,'2MEM','2MMO','NB2','ZBPU','ZD2S','ZKR','ZEU1','ZIN1','OR','UB'),

                                         'test'

                                )

                           )

                      )

                 ) as Group

            From [Whatever];

             

            in this way, you can put the dimension on the pivot table.

             

            As to the total, you wouldn't need to create another field with a total qualifier. on the presentation tab of the pivot table, you can choose the "Totals" to create what you want.

             

            Felipe.