Sorting pivot date data into date order

[Marvick1]

Hi,

From the outset, I find the suggestions/data on this forum really useful and have aided me with many problems over the past few years.

This one has me stumped & I've tried everything - I have a Pivot of date data, showing the value of compensation raised, by month, by subject (dummy example below):

[TABLE="width: 713"]
<COLGROUP><COL style="WIDTH: 253pt; mso-width-source: userset; mso-width-alt: 12324" width=337><COL style="WIDTH: 82pt; mso-width-source: userset; mso-width-alt: 3986" span=5 width=109><COL style="WIDTH: 50pt; mso-width-source: userset; mso-width-alt: 2450" width=67><TBODY>[TR]
[TD="class: xl65, width: 337, bgcolor: transparent"]Sum of Value of Cheque[/TD]
[TD="class: xl73, width: 109, bgcolor: transparent"]MONTH RAISED[/TD]
[TD="class: xl74, width: 109, bgcolor: transparent"] [/TD]
[TD="class: xl74, width: 109, bgcolor: transparent"] [/TD]
[TD="class: xl74, width: 109, bgcolor: transparent"] [/TD]
[TD="class: xl74, width: 109, bgcolor: transparent"] [/TD]
[TD="class: xl75, width: 67, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]Cost Type[/TD]
[TD="class: xl73, bgcolor: transparent"]August-2012[/TD]
[TD="class: xl76, bgcolor: transparent"]July-2012[/TD]
[TD="class: xl76, bgcolor: transparent"]June-2012[/TD]
[TD="class: xl76, bgcolor: transparent"]May-2012[/TD]
[TD="class: xl76, bgcolor: transparent"]September-2012[/TD]
[TD="class: xl77, bgcolor: transparent"]Grand Total[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]1.1 Reservations/Administration (A. SALES/AFTER SALES)[/TD]
[TD="class: xl67, bgcolor: transparent"]£0.00[/TD]
[TD="class: xl68, bgcolor: transparent"]£89.51[/TD]
[TD="class: xl68, bgcolor: transparent"]£150.00[/TD]
[TD="class: xl68, bgcolor: transparent"]£7.10[/TD]
[TD="class: xl68, bgcolor: transparent"]£251.30[/TD]
[TD="class: xl69, bgcolor: transparent"]£497.91[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]1.2 Ticketing/TOD issues/Documentation (A. SALES/AFTER SALES)[/TD]
[TD="class: xl70, bgcolor: transparent"]£0.00[/TD]
[TD="class: xl71, bgcolor: transparent"]£0.00[/TD]
[TD="class: xl71, bgcolor: transparent"]£50.00[/TD]
[TD="class: xl71, bgcolor: transparent"]£120.00[/TD]
[TD="class: xl71, bgcolor: transparent"]£0.00[/TD]
[TD="class: xl72, bgcolor: transparent"]£170.00[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]1.3 Website technical issues (A. SALES/AFTER SALES)[/TD]
[TD="class: xl70, bgcolor: transparent"]£219.42[/TD]
[TD="class: xl71, bgcolor: transparent"]£0.00[/TD]
[TD="class: xl71, bgcolor: transparent"]£0.00[/TD]
[TD="class: xl71, bgcolor: transparent"]£55.00[/TD]
[TD="class: xl71, bgcolor: transparent"]£0.00[/TD]
[TD="class: xl72, bgcolor: transparent"]£274.42[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]1.4 Holiday Cost (errors/price changes) (A. SALES/AFTER SALES)[/TD]
[TD="class: xl70, bgcolor: transparent"]£0.00[/TD]
[TD="class: xl71, bgcolor: transparent"]£215.73[/TD]
[TD="class: xl71, bgcolor: transparent"]£140.00[/TD]
[TD="class: xl71, bgcolor: transparent"]£0.00[/TD]
[TD="class: xl71, bgcolor: transparent"]£0.00[/TD]
[TD="class: xl72, bgcolor: transparent"]£355.73[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]1.5 Travel Agent issue (A. SALES/AFTER SALES)[/TD]
[TD="class: xl70, bgcolor: transparent"]£232.00[/TD]
[TD="class: xl71, bgcolor: transparent"]£0.00[/TD]
[TD="class: xl71, bgcolor: transparent"]£0.00[/TD]
[TD="class: xl71, bgcolor: transparent"]£0.00[/TD]
[TD="class: xl71, bgcolor: transparent"]£100.00[/TD]
[TD="class: xl72, bgcolor: transparent"]£332.00[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]1.6 Special Needs (not actioned/provided) (A. SALES/AFTER SALES)[/TD]
[TD="class: xl70, bgcolor: transparent"]£0.00[/TD]
[TD="class: xl71, bgcolor: transparent"]£100.00[/TD]
[TD="class: xl71, bgcolor: transparent"]£0.00[/TD]
[TD="class: xl71, bgcolor: transparent"]£0.00[/TD]
[TD="class: xl71, bgcolor: transparent"]£150.00[/TD]
[TD="class: xl72, bgcolor: transparent"]£250.00[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[TD="class: xl71, bgcolor: transparent"][/TD]
[TD="class: xl71, bgcolor: transparent"][/TD]
[TD="class: xl71, bgcolor: transparent"][/TD]
[TD="class: xl71, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[/TR]
</TBODY>[/TABLE]

The most simplest task - sort the "Month Raised" dates into date order - stopped me in my tracks.

I KNOW it must be simple, I KNOW I'm missing something really obvious but could I do it? No.

Any help REALLY appreciated!

Thanks in advance!

 

[scottsen]

Hi Marverick,

If you are indeed using Power Pivot this is easily done using the "Sort By Column Feature", seen here PowerPivot: Sort by column - Geeky Girl - Site Home - TechNet Blogs

If not, you should redirect your question to the general excel forum, where you will get more answers