Pivot Table not Sorting Dates Correctly HELP!

CDICKENS · Mar 25th, 2002, 07:27 AM

I have a daily sales report for different product types in excel. I am using a pivot table to calculate the data. Twice since the first of the year after adding new sales and refreshing the pivot table, the "new" dates are not in chronological order. This messes up my formula for displaying the information in my report. I have to reassign which cells in the pivot table my report should be looking at.

Is there a better way to set up this report or another way to sort the pivot table?

Thanks,

Chuck

paelinck · Mar 25th, 2002, 07:38 AM

Have you tried this?
Double click the date header in the pivot table and click the "Advanced..." button. Select the "Ascending" options on Autosort Options and choose the field you want to sort on.

Marc

CDICKENS · Mar 25th, 2002, 09:54 AM

That appeared to work...

except one date did not fall back in line. I can live with that.

THanks
CHuck

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 25th, 2002, 07:27 AM	#1
CDICKENS Board Regular Join Date: Mar 2002 Posts: 444	I have a daily sales report for different product types in excel. I am using a pivot table to calculate the data. Twice since the first of the year after adding new sales and refreshing the pivot table, the "new" dates are not in chronological order. This messes up my formula for displaying the information in my report. I have to reassign which cells in the pivot table my report should be looking at. Is there a better way to set up this report or another way to sort the pivot table? Thanks, Chuck

Mar 25th, 2002, 07:38 AM	#2
paelinck Board Regular Join Date: Mar 2002 Location: Leiden, The Netherlands Posts: 68	Have you tried this? Double click the date header in the pivot table and click the "Advanced..." button. Select the "Ascending" options on Autosort Options and choose the field you want to sort on. Marc

Mar 25th, 2002, 09:54 AM	#3
CDICKENS Board Regular Join Date: Mar 2002 Posts: 444	That appeared to work... except one date did not fall back in line. I can live with that. THanks CHuck