Sort Date Dimension in Pivot Table

[joshabbott]

I'm trying to sort by date in a pivot table that will be 'pivoted'.  There are two dimensions that I'm using, Letter, and Date.  I want the dates over the top to be sorted over the sorted letters:

Example:

            1/1/2015                 2/10/2015       etc

A

B

C

D

I know I've had problems with this in the past, and am just 'stuck'.  Thank you for any help, example attached.

[Anonymous]

I'm not sure I understand the problem...  Try to sort Letter by text and Date by number.

[joshabbott]

I did, and unfortunately, that didn't work.  I want on the left for it to be sorted by 'Letter' and on pivot over top of the pivot table, it to be sorted by date:

[#4]

Sort the date by Numeric Value and Letter by Text.

[Anonymous · Accepted solution]

It works for me - see attached.  Or I don't understand what you need...

[joshabbott]

You're right, I thought I'd tried that.  Thank you!