3 Replies Latest reply on May 13, 2016 8:44 AM by Lee Forst

    Sort state and sub-category based on Sales

    Lee Forst

      I seem to have a mental block this morning on how to achieve a multi-dimensional sort.  In the attached workbook, you'll find the first sheet, Sort States, is sorted based on sum of sales on State.  The second sheet, Sort Subcats, has each sub cat sorted within the states.  What I really want is this sheet to have first sorted by State and then within each state have the Sub-cats sorted.  So California would be the first state (having highest overall sales) and then the Subs within Cali would be sorted (Phones, Chairs, Tables,..., Fasteners) and then would come New York with its subs sorted (Phones, Chairs, Machines,..., Fasteners) all the way through North Dakota being lasted with Storage, Art, Binders, and Fasteners.