Results 1 to 3 of 3

Repeating Labels & Controlling Sort in Pivots

Threaded View

  1. #1
    Forum Contributor
    Join Date
    01-16-2011
    Location
    Abu Dhabi, UAE
    MS-Off Ver
    Excel 2010
    Posts
    234

    Repeating Labels & Controlling Sort in Pivots

    I have a large table, and one of the columns in the table is the date.

    I'm extracting a pivot table from this table and sorting it by date. However, if two or more rows have the same date, the date only shows up on the first row, and in subsequent rows where the date is the same, the date is blank. I need it to appear on all rows.

    In another pivot table from the same table, the data needs to be unsorted, i.e. in the same order as in the original table. But if a row is inserted into the original table mid-table, it doesn't appear mid-table, but at the bottom of the table.

    Thanks!
    Last edited by DonkeyOte; 02-01-2011 at 09:08 AM.

Thread Information

Users Browsing this Thread

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

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