+ Reply to Thread
Results 1 to 1 of 1

Sort pivot table on data fields

  1. #1
    Registered User
    Join Date
    12-14-2011
    Location
    Boras, Sweden
    MS-Off Ver
    Excel 2003
    Posts
    1

    Unhappy Sort pivot table on data fields

    I've failed to see the probably easy solution for this!

    I have a pivot table that needs to be sorted after the data field,
    not the sum of the rows, more of how the numbers come up.

    I can't figure out how to sort IndexNo so that it starts with row 2, and then 1 & 3 (sort the data by column 1, then 2, and so on...)

    The real pivot is a lot bigger, but this is to get the idea. :)


    Sum of SubQty...I..Materials
    IndexNo............I Material 1.....I Material 2..I Material 3...I
    ----------------+-------------+-----------+------------I
    12345...............I........2.................0................1........I
    ----------------+-------------+-----------+------------I
    22222...............I........2.................1................0........I
    ----------------+-------------+-----------+------------I
    66611...............I........2.................0................1........I
    ----------------+-------------+-----------+------------I

    Looking forward to see how dumb I can feel when the solution is presented! ;)
    Last edited by Pala; 09-28-2012 at 07:09 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1