+ Reply to Thread
Results 1 to 3 of 3

Pivot Table Sorting of Rows

Hybrid View

  1. 10-13-2016, 01:32 PM #1
    Dnaka11
    Dnaka11 is offline
    Registered User
    Join Date
    10-13-2016
    Location
    Kelowna, Canada
    MS-Off Ver
    2013
    Posts
    2

    Pivot Table Sorting of Rows

    Hi, I am working in Excel 2013. I have a Pivot Table and I would like to sort the information by the dates I have in the 5th row. As I understand you can only sort information in the first row using the dropdowns, or the sort function. Is there any way to work around this?
    Reply With QuoteRegister To Reply
  2. 10-13-2016, 01:44 PM #2
    PeteABC123
    PeteABC123 is offline
    Valued Forum Contributor PeteABC123's Avatar
    Join Date
    09-21-2012
    Location
    Chicago, IL
    MS-Off Ver
    MS Office 365 ver 2202
    Posts
    1,104

    Re: Pivot Table Sorting of Rows

    Do you mean 5th column?
    Reply With QuoteRegister To Reply
  3. 10-13-2016, 01:46 PM #3
    Dnaka11
    Dnaka11 is offline
    Registered User
    Join Date
    10-13-2016
    Location
    Kelowna, Canada
    MS-Off Ver
    2013
    Posts
    2

    Re: Pivot Table Sorting of Rows

    Well it is a column header, but it is in the row field.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Sorting a pivot table and data outside of the table
    By nicki_rae22 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 12-06-2013, 12:57 PM
  2. Pivot Table Sorting
    By christ.naveen in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 03-07-2013, 06:44 AM
  3. Excel 2007 : pivot table sorting
    By Kolacube in forum Excel General
    Replies: 0
    Last Post: 03-24-2011, 03:30 AM
  4. Pivot Table Row Sorting
    By aschwalge in forum Excel General
    Replies: 1
    Last Post: 10-03-2010, 09:09 AM
  5. Pivot Table Sorting
    By Simon1185 in forum Excel General
    Replies: 3
    Last Post: 06-09-2009, 05:50 AM
  6. Sorting in the pivot table
    By globi in forum Excel General
    Replies: 2
    Last Post: 01-16-2008, 03:21 AM
  7. Sorting rows in Pivot table
    By hstijnen in forum Excel General
    Replies: 2
    Last Post: 06-13-2006, 09:20 AM
  8. [SOLVED] pivot table sorting
    By Debra Dalgleish in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 09-06-2005, 03:05 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1