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!

First up - please keep titles as specific to the underlying problem(s) as possible

Originally Posted by Hambone70

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.

If using XL2010 as implied see: http://office.microsoft.com/en-us/ex...101821017.aspx

Originally Posted by Hambone

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.

Not sure about this one I'm afraid - if the date is the first field the Pivot will auto sort I think ... often wrong though.