Pivot Table not Sorting Dates Correctly HELP!

CDICKENS

Active Member
Joined
Mar 24, 2002
Messages
498
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
 

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest
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
 
Upvote 0
That appeared to work...

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

THanks
CHuck
 
Upvote 0

Forum statistics

Threads
1,213,581
Messages
6,114,461
Members
448,573
Latest member
BEDE

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top