Pivot table is not shown in sorted order of date

[Azizrmd]

I am creating a pivot table with source sheet as follows:

Date	Entity	Amount	Status
7/2/2013	ParkingB	0.0	IN
7/3/2013	ParkingB	36,107.6	IN
7/4/2013	ParkingB	0.0	IN
7/4/2013	AppleC	547.8	OUT
7/4/2013	AppleC	0.0	IN
7/5/2013	AppleC	0.0	IN
7/5/2013	Darkness	0.0	IN
7/5/2013	BarF	0.0	OUT
7/5/2013	BarF	20.2	IN
7/6/2013	BarF	1,556.0	IN
7/7/2013	ParkingB	10,866.2	OUT
7/7/2013	ParkingB	1,925.3	IN
7/7/2013	AppleC	256.2	OUT
7/7/2013	AppleC	135.2	IN
7/7/2013	BarF	2,268.9	OUT
7/7/2013	BarF	1,822.0	IN
7/9/2013	ParkingB	941.5	OUT
7/9/2013	ParkingB	47,993.9	IN
7/9/2013	AppleC	50.5	OUT
7/9/2013	AppleC	577.7	IN
7/9/2013	Darkness	0.0	OUT
7/9/2013	Darkness	0.0	IN
7/9/2013	BarF	1,177.1	OUT
7/9/2013	BarF	3,427.6	IN
7/11/2013	ParkingB	366.7	OUT
7/11/2013	ParkingB	9,898.0	IN
7/11/2013	AppleC	0.0	OUT
7/11/2013	AppleC	101.6	IN
7/11/2013	Darkness	0.0	OUT
7/11/2013	Darkness	0.0	IN
7/11/2013	BarF	283.3	OUT
7/11/2013	BarF	1,956.2	IN
7/12/2013	ParkingB	58,899.9	OUT
7/12/2013	ParkingB	1,898.0	IN
7/13/2013	ParkingB	62,457.7	OUT
7/13/2013	ParkingB	4,326.7	IN
7/14/2013	ParkingB	16,179.4	OUT
7/14/2013	ParkingB	2,365.5	IN
7/15/2013	ParkingB	10,264.7	IN
7/15/2013	AppleC	101.6	IN
7/15/2013	Darkness	0.0	IN
7/15/2013	BarF	2,239.5	IN
7/16/2013	ParkingB	941.5	OUT
7/16/2013	ParkingB	47,993.9	IN
7/16/2013	AppleC	50.5	OUT
7/16/2013	AppleC	577.7	IN
7/16/2013	Darkness	0.0	OUT
7/16/2013	Darkness	0.0	IN
7/16/2013	BarF	1,177.1	OUT
7/16/2013	BarF	3,427.6	IN
7/17/2013	ParkingB	0.2	OUT
7/17/2013	ParkingB	48,899.0	IN
7/17/2013	AppleC	0.0	OUT
7/17/2013	AppleC	939.2	IN
7/17/2013	Darkness	0.0	IN
7/17/2013	BarF	24.0	OUT
7/17/2013	BarF	5,643.1	IN
7/18/2013	ParkingB	10,264.7	OUT
7/18/2013	AppleC	101.6	OUT
7/18/2013	Darkness	0.0	OUT
7/18/2013	BarF	2,055.3	OUT
7/18/2013	BarF	184.2	IN

<colgroup><col><col><col><col></colgroup><tbody>
</tbody>

The pivot are created like this:

Amount	Date	Status
	7/11/2013		7/11/2013 Total	7/12/2013		7/12/2013 Total	7/13/2013		7/13/2013 Total	7/14/2013		7/14/2013 Total	7/15/2013	7/15/2013 Total	7/16/2013		7/16/2013 Total	7/17/2013		7/17/2013 Total	7/18/2013		7/18/2013 Total	7/2/2013	7/2/2013 Total	7/3/2013	7/3/2013 Total	7/4/2013		7/4/2013 Total	7/5/2013		7/5/2013 Total	7/6/2013	7/6/2013 Total	7/7/2013		7/7/2013 Total	7/9/2013		7/9/2013 Total
Entity	IN	OUT		IN	OUT		IN	OUT		IN	OUT		IN		IN	OUT		IN	OUT		IN	OUT		IN		IN		IN	OUT		IN	OUT		IN		IN	OUT		IN	OUT
AppleC	101.6	0.0	101.6										101.6	101.6	577.7	50.5	628.2	939.2	0.0	939.2		101.6	101.6					0.0	547.8	547.8	0.0		0.0			135.2	256.2	391.4	577.7	50.5	628.2
BarF	1,956.2	283.3	2,239.5										2,239.5	2,239.5	3,427.6	1,177.1	4,604.7	5,643.1	24.0	5,667.1	184.2	2,055.3	2,239.5								20.2	0.0	20.2	1,556.0	1,556.0	1,822.0	2,268.9	4,090.9	3,427.6	1,177.1	4,604.7
Darkness	0.0	0.0	0.0										0.0	0.0	0.0	0.0	0.0	0.0		0.0		0.0	0.0								0.0		0.0						0.0	0.0	0.0
ParkingB	9,898.0	366.7	10,264.7	1,898.0	58,899.9	60,797.9	4,326.7	62,457.7	66,784.4	2,365.5	16,179.4	18,544.9	10,264.7	10,264.7	47,993.9	941.5	48,935.4	48,899.0	0.2	48,899.2		10,264.7	10,264.7	0.0	0.0	36,107.6	36,107.6	0.0		0.0						1,925.3	10,866.2	12,791.5	47,993.9	941.5	48,935.4
Grand Total	11,955.7	650.0	12,605.7	1,898.0	58,899.9	60,797.9	4,326.7	62,457.7	66,784.4	2,365.5	16,179.4	18,544.9	12,605.7	12,605.7	51,999.2	2,169.1	54,168.4	55,481.3	24.2	55,505.6	184.2	12,421.5	12,605.7	0.0	0.0	36,107.6	36,107.6	0.0	547.8	547.8	20.2	0.0	20.2	1,556.0	1,556.0	3,882.5	13,391.3	17,273.8	51,999.2	2,169.1	54,168.4

<colgroup><col style="mso-width-source:userset;mso-width-alt:2889;width:59pt" width="79"> <col style="mso-width-source:userset;mso-width-alt:2962; width:61pt" width="81" span="2"> <col style="mso-width-source:userset;mso-width-alt:3766;width:77pt" width="103"> <col style="mso-width-source:userset;mso-width-alt:2962; width:61pt" width="81" span="2"> <col style="mso-width-source:userset;mso-width-alt:3766;width:77pt" width="103"> <col style="mso-width-source:userset;mso-width-alt:2962; width:61pt" width="81" span="2"> <col style="mso-width-source:userset;mso-width-alt:3766;width:77pt" width="103"> <col style="mso-width-source:userset;mso-width-alt:2962; width:61pt" width="81" span="2"> <col style="mso-width-source:userset;mso-width-alt:3766;width:77pt" width="103"> <col style="mso-width-source:userset;mso-width-alt:2962;width:61pt" width="81"> <col style="mso-width-source:userset;mso-width-alt:3766;width:77pt" width="103"> <col style="mso-width-source:userset;mso-width-alt:2962; width:61pt" width="81" span="2"> <col style="mso-width-source:userset;mso-width-alt:3766;width:77pt" width="103"> <col style="mso-width-source:userset;mso-width-alt:2962; width:61pt" width="81" span="2"> <col style="mso-width-source:userset;mso-width-alt:3766;width:77pt" width="103"> <col style="mso-width-source:userset;mso-width-alt:2962; width:61pt" width="81" span="2"> <col style="mso-width-source:userset;mso-width-alt:3766;width:77pt" width="103"> <col style="mso-width-source:userset;mso-width-alt:2706;width:56pt" width="74"> <col style="mso-width-source:userset;mso-width-alt:3510;width:72pt" width="96"> <col style="mso-width-source:userset;mso-width-alt:2706;width:56pt" width="74"> <col style="mso-width-source:userset;mso-width-alt:3510;width:72pt" width="96"> <col style="mso-width-source:userset;mso-width-alt:2706; width:56pt" width="74" span="2"> <col style="mso-width-source:userset;mso-width-alt:3510;width:72pt" width="96"> <col style="mso-width-source:userset;mso-width-alt:2706; width:56pt" width="74" span="2"> <col style="mso-width-source:userset;mso-width-alt:3510;width:72pt" width="96"> <col style="mso-width-source:userset;mso-width-alt:2706;width:56pt" width="74"> <col style="mso-width-source:userset;mso-width-alt:3510;width:72pt" width="96"> <col style="mso-width-source:userset;mso-width-alt:2706; width:56pt" width="74" span="2"> <col style="mso-width-source:userset;mso-width-alt:3510;width:72pt" width="96"> <col style="mso-width-source:userset;mso-width-alt:2706; width:56pt" width="74" span="2"> <col style="mso-width-source:userset;mso-width-alt:3510;width:72pt" width="96"> </colgroup><tbody>
</tbody>

Here the dates are not shown here in proper order. Please suggest what should i do so that the pivot starts from 2 july 2013 and not 11 July 2013.
Any help would be much appreciated.

p.s the first column is formatted as a date column.

Thank you,
Aziz

p

 

[Andrew Poulsom]

Welcome to MrExcel.

Are you sure that your dates are serial dates not text? You can use the ISNUMBER function to check (TRUE for a serial date, FALSE for text).

 

[Azizrmd]

Hello Andrew,
Thank you for your reply, appreciate it.
I used ISNUMBER function and the result was false. Can you suggest how should i make it date, though is shows it is formatted as date. Actually i am putting the data in the sheet through code i.e.I have a datatable with first column as date and putting those values in a predefined template (where first column is set as date). After inserting the values the pivots are created and there it get messed up.

Please advise as how i can build the pivots with sorted date.

Many thanks!

 

[Andrew Poulsom]

What code are you using to enter the dates?

For conversion you can use Data|Text To Columns, checking Date MDY at Step 3 of the Wizard.

 

[Azizrmd]

Thank you Andrew. Your replies really helped me to figure out the problem.