2 Replies Latest reply on Apr 29, 2013 11:11 PM by Santichai Jong

    Asking for sorting problem !!

    Santichai Jong

      Hi,

       

      Anyone can help me for do this, Left side the data display and sort by subcategory (default A-Z).

      I need to sort the data by "Sales Amt" when I click it the screen display in the right side it's not correct.

       

       

      tab02.jpg

       

      Data should be display as

      DRP ANTISTATIS-PINK(C..     67,260.00
      ORDINARY (ROLL)                  60,500.00
      DRP ORDINA (ROLL)              50,940.00

      .........

      ........

       

      How to sort to correct, Anyone can be help or suggest for the solution?

       

      Thanks

      J.Santichai

        • 1. Re: Asking for sorting problem !!
          Jim Wahl

          Hi Jong,

           

          When you select sort-by for a dimension, such as Subcategory > Sort by Sales_Amt, Tableau sorts using the global value for Sales_Amt (without regard to the other dimension you've added).

           

          For example, if you start with

          Subcategory     Sales

          Subcat1             125

          Subcat2             100

           

          Then add Category

           

          Category     Subcategory     Sales

          Cat1            Subcat1             100

                               Subcat2               50

          Cat2            Subcat1               25

                               Subcat2               50

           

          The sort order is still Subcat1, Subcat2, even though Subcat2 was higher for Cat2. ...

           

          You can avoid this by creating a set consisting of all the dimensions in the view and then creating a set and sorting by that set:

          Category     Subcategory     Sales

          Cat1            Subcat1             100

                              Subcat2               50

          Cat2            Subcat2               50

                              Subcat1               25

           

          See Nested Sorting | Tableau Software.

           

          Jim

          • 2. Re: Asking for sorting problem !!
            Santichai Jong

            Hi Jim Wahl,

             

            It's work !!

             

            Thank you for your reply.

             

            J.Santichai

             

            xxxxxx.jpg