Pivot table is not shown in sorted order of date

A

Azizrmd

New Member
Joined
Jul 18, 2013
Messages
9
I am creating a pivot table with source sheet as follows:
[TABLE="width: 325"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD]Date[/TD]
[TD]Entity
[/TD]
[TD]Amount
[/TD]
[TD]Status[/TD]
[/TR]
[TR]
[TD]7/2/2013[/TD]
[TD]ParkingB[/TD]
[TD="align: right"]0.0[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD]7/3/2013[/TD]
[TD]ParkingB[/TD]
[TD="align: right"]36,107.6[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD]7/4/2013[/TD]
[TD]ParkingB[/TD]
[TD="align: right"]0.0[/TD]
[TD]IN
[/TD]
[/TR]
[TR]
[TD]7/4/2013[/TD]
[TD]AppleC[/TD]
[TD="align: right"]547.8[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD]7/4/2013[/TD]
[TD]AppleC[/TD]
[TD="align: right"]0.0[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD]7/5/2013[/TD]
[TD]AppleC[/TD]
[TD="align: right"]0.0[/TD]
[TD]IN
[/TD]
[/TR]
[TR]
[TD]7/5/2013[/TD]
[TD]Darkness[/TD]
[TD="align: right"]0.0[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD]7/5/2013[/TD]
[TD]BarF[/TD]
[TD="align: right"]0.0[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD]7/5/2013[/TD]
[TD]BarF[/TD]
[TD="align: right"]20.2[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD]7/6/2013[/TD]
[TD]BarF[/TD]
[TD="align: right"]1,556.0[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD]7/7/2013[/TD]
[TD]ParkingB[/TD]
[TD="align: right"]10,866.2[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD]7/7/2013[/TD]
[TD]ParkingB[/TD]
[TD="align: right"]1,925.3[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD]7/7/2013[/TD]
[TD]AppleC[/TD]
[TD="align: right"]256.2[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD]7/7/2013[/TD]
[TD]AppleC[/TD]
[TD="align: right"]135.2[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD]7/7/2013[/TD]
[TD]BarF[/TD]
[TD="align: right"]2,268.9[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD]7/7/2013[/TD]
[TD]BarF[/TD]
[TD="align: right"]1,822.0[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD]7/9/2013[/TD]
[TD]ParkingB[/TD]
[TD="align: right"]941.5[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD]7/9/2013[/TD]
[TD]ParkingB[/TD]
[TD="align: right"]47,993.9[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD]7/9/2013[/TD]
[TD]AppleC[/TD]
[TD="align: right"]50.5[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD]7/9/2013[/TD]
[TD]AppleC[/TD]
[TD="align: right"]577.7[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD]7/9/2013[/TD]
[TD]Darkness[/TD]
[TD="align: right"]0.0[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD]7/9/2013[/TD]
[TD]Darkness[/TD]
[TD="align: right"]0.0[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD]7/9/2013[/TD]
[TD]BarF[/TD]
[TD="align: right"]1,177.1[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD]7/9/2013[/TD]
[TD]BarF[/TD]
[TD="align: right"]3,427.6[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD]7/11/2013[/TD]
[TD]ParkingB[/TD]
[TD="align: right"]366.7[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD]7/11/2013[/TD]
[TD]ParkingB[/TD]
[TD="align: right"]9,898.0[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD]7/11/2013[/TD]
[TD]AppleC[/TD]
[TD="align: right"]0.0[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD]7/11/2013[/TD]
[TD]AppleC[/TD]
[TD="align: right"]101.6[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD]7/11/2013[/TD]
[TD]Darkness[/TD]
[TD="align: right"]0.0[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD]7/11/2013[/TD]
[TD]Darkness[/TD]
[TD="align: right"]0.0[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD]7/11/2013[/TD]
[TD]BarF[/TD]
[TD="align: right"]283.3[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD]7/11/2013[/TD]
[TD]BarF[/TD]
[TD="align: right"]1,956.2[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD]7/12/2013[/TD]
[TD]ParkingB[/TD]
[TD="align: right"]58,899.9[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD]7/12/2013[/TD]
[TD]ParkingB[/TD]
[TD="align: right"]1,898.0[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD]7/13/2013[/TD]
[TD]ParkingB[/TD]
[TD="align: right"]62,457.7[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD]7/13/2013[/TD]
[TD]ParkingB[/TD]
[TD="align: right"]4,326.7[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD]7/14/2013[/TD]
[TD]ParkingB[/TD]
[TD="align: right"]16,179.4[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD]7/14/2013[/TD]
[TD]ParkingB[/TD]
[TD="align: right"]2,365.5[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD]7/15/2013[/TD]
[TD]ParkingB[/TD]
[TD="align: right"]10,264.7[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD]7/15/2013[/TD]
[TD]AppleC[/TD]
[TD="align: right"]101.6[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD]7/15/2013[/TD]
[TD]Darkness[/TD]
[TD="align: right"]0.0[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD]7/15/2013[/TD]
[TD]BarF[/TD]
[TD="align: right"]2,239.5[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD]7/16/2013[/TD]
[TD]ParkingB[/TD]
[TD="align: right"]941.5[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD]7/16/2013[/TD]
[TD]ParkingB[/TD]
[TD="align: right"]47,993.9[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD]7/16/2013[/TD]
[TD]AppleC[/TD]
[TD="align: right"]50.5[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD]7/16/2013[/TD]
[TD]AppleC[/TD]
[TD="align: right"]577.7[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD]7/16/2013[/TD]
[TD]Darkness[/TD]
[TD="align: right"]0.0[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD]7/16/2013[/TD]
[TD]Darkness[/TD]
[TD="align: right"]0.0[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD]7/16/2013[/TD]
[TD]BarF[/TD]
[TD="align: right"]1,177.1[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD]7/16/2013[/TD]
[TD]BarF[/TD]
[TD="align: right"]3,427.6[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD]7/17/2013[/TD]
[TD]ParkingB[/TD]
[TD="align: right"]0.2[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD]7/17/2013[/TD]
[TD]ParkingB[/TD]
[TD="align: right"]48,899.0[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD]7/17/2013[/TD]
[TD]AppleC[/TD]
[TD="align: right"]0.0[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD]7/17/2013[/TD]
[TD]AppleC[/TD]
[TD="align: right"]939.2[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD]7/17/2013[/TD]
[TD]Darkness[/TD]
[TD="align: right"]0.0[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD]7/17/2013[/TD]
[TD]BarF[/TD]
[TD="align: right"]24.0[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD]7/17/2013[/TD]
[TD]BarF[/TD]
[TD="align: right"]5,643.1[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD]7/18/2013[/TD]
[TD]ParkingB[/TD]
[TD="align: right"]10,264.7[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD]7/18/2013[/TD]
[TD]AppleC[/TD]
[TD="align: right"]101.6[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD]7/18/2013[/TD]
[TD]Darkness[/TD]
[TD="align: right"]0.0[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD]7/18/2013[/TD]
[TD]BarF[/TD]
[TD="align: right"]2,055.3[/TD]
[TD]OUT[/TD]
[/TR]
[TR]
[TD]7/18/2013[/TD]
[TD]BarF[/TD]
[TD="align: right"]184.2[/TD]
[TD]IN[/TD]
[/TR]
</tbody>[/TABLE]

The pivot are created like this:


<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>
[TD="class: xl65, width: 79"]Amount[/TD]
[TD="class: xl65, width: 81"]Date[/TD]
[TD="class: xl65, width: 81"]Status[/TD]
[TD="class: xl65, width: 103"][/TD]
[TD="class: xl65, width: 81"][/TD]
[TD="class: xl65, width: 81"][/TD]
[TD="class: xl65, width: 103"][/TD]
[TD="class: xl65, width: 81"][/TD]
[TD="class: xl65, width: 81"][/TD]
[TD="class: xl65, width: 103"][/TD]
[TD="class: xl65, width: 81"][/TD]
[TD="class: xl65, width: 81"][/TD]
[TD="class: xl65, width: 103"][/TD]
[TD="class: xl65, width: 81"][/TD]
[TD="class: xl65, width: 103"][/TD]
[TD="class: xl65, width: 81"][/TD]
[TD="class: xl65, width: 81"][/TD]
[TD="class: xl65, width: 103"][/TD]
[TD="class: xl65, width: 81"][/TD]
[TD="class: xl65, width: 81"][/TD]
[TD="class: xl65, width: 103"][/TD]
[TD="class: xl65, width: 81"][/TD]
[TD="class: xl65, width: 81"][/TD]
[TD="class: xl65, width: 103"][/TD]
[TD="class: xl65, width: 74"][/TD]
[TD="class: xl65, width: 96"][/TD]
[TD="class: xl65, width: 74"][/TD]
[TD="class: xl65, width: 96"][/TD]
[TD="class: xl65, width: 74"][/TD]
[TD="class: xl65, width: 74"][/TD]
[TD="class: xl65, width: 96"][/TD]
[TD="class: xl65, width: 74"][/TD]
[TD="class: xl65, width: 74"][/TD]
[TD="class: xl65, width: 96"][/TD]
[TD="class: xl65, width: 74"][/TD]
[TD="class: xl65, width: 96"][/TD]
[TD="class: xl65, width: 74"][/TD]
[TD="class: xl65, width: 74"][/TD]
[TD="class: xl65, width: 96"][/TD]
[TD="class: xl65, width: 74"][/TD]
[TD="class: xl65, width: 74"][/TD]
[TD="class: xl65, width: 96"][/TD]

[TD="class: xl65"][/TD]
[TD="class: xl65"]7/11/2013[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]7/11/2013 Total[/TD]
[TD="class: xl65"]7/12/2013[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]7/12/2013 Total[/TD]
[TD="class: xl65"]7/13/2013[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]7/13/2013 Total[/TD]
[TD="class: xl65"]7/14/2013[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]7/14/2013 Total[/TD]
[TD="class: xl65"]7/15/2013[/TD]
[TD="class: xl65"]7/15/2013 Total[/TD]
[TD="class: xl65"]7/16/2013[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]7/16/2013 Total[/TD]
[TD="class: xl65"]7/17/2013[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]7/17/2013 Total[/TD]
[TD="class: xl65"]7/18/2013[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]7/18/2013 Total[/TD]
[TD="class: xl65"]7/2/2013[/TD]
[TD="class: xl65"]7/2/2013 Total[/TD]
[TD="class: xl65"]7/3/2013[/TD]
[TD="class: xl65"]7/3/2013 Total[/TD]
[TD="class: xl65"]7/4/2013[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]7/4/2013 Total[/TD]
[TD="class: xl65"]7/5/2013[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]7/5/2013 Total[/TD]
[TD="class: xl65"]7/6/2013[/TD]
[TD="class: xl65"]7/6/2013 Total[/TD]
[TD="class: xl65"]7/7/2013[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]7/7/2013 Total[/TD]
[TD="class: xl65"]7/9/2013[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]7/9/2013 Total[/TD]

[TD="class: xl65"]Entity[/TD]
[TD="class: xl65"]IN[/TD]
[TD="class: xl65"]OUT[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]IN[/TD]
[TD="class: xl65"]OUT[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]IN[/TD]
[TD="class: xl65"]OUT[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]IN[/TD]
[TD="class: xl65"]OUT[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]IN[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]IN[/TD]
[TD="class: xl65"]OUT[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]IN[/TD]
[TD="class: xl65"]OUT[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]IN[/TD]
[TD="class: xl65"]OUT[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]IN[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]IN[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]IN[/TD]
[TD="class: xl65"]OUT[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]IN[/TD]
[TD="class: xl65"]OUT[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]IN[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]IN[/TD]
[TD="class: xl65"]OUT[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]IN[/TD]
[TD="class: xl65"]OUT[/TD]
[TD="class: xl65"][/TD]

[TD="class: xl65"]AppleC[/TD]
[TD="class: xl65, align: right"]101.6[/TD]
[TD="class: xl65, align: right"]0.0[/TD]
[TD="class: xl65, align: right"]101.6[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65, align: right"]101.6[/TD]
[TD="class: xl65, align: right"]101.6[/TD]
[TD="class: xl65, align: right"]577.7[/TD]
[TD="class: xl65, align: right"]50.5[/TD]
[TD="class: xl65, align: right"]628.2[/TD]
[TD="class: xl65, align: right"]939.2[/TD]
[TD="class: xl65, align: right"]0.0[/TD]
[TD="class: xl65, align: right"]939.2[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65, align: right"]101.6[/TD]
[TD="class: xl65, align: right"]101.6[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65, align: right"]0.0[/TD]
[TD="class: xl65, align: right"]547.8[/TD]
[TD="class: xl65, align: right"]547.8[/TD]
[TD="class: xl65, align: right"]0.0[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65, align: right"]0.0[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65, align: right"]135.2[/TD]
[TD="class: xl65, align: right"]256.2[/TD]
[TD="class: xl65, align: right"]391.4[/TD]
[TD="class: xl65, align: right"]577.7[/TD]
[TD="class: xl65, align: right"]50.5[/TD]
[TD="class: xl65, align: right"]628.2[/TD]

[TD="class: xl65"]BarF[/TD]
[TD="class: xl65, align: right"]1,956.2[/TD]
[TD="class: xl65, align: right"]283.3[/TD]
[TD="class: xl65, align: right"]2,239.5[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65, align: right"]2,239.5[/TD]
[TD="class: xl65, align: right"]2,239.5[/TD]
[TD="class: xl65, align: right"]3,427.6[/TD]
[TD="class: xl65, align: right"]1,177.1[/TD]
[TD="class: xl65, align: right"]4,604.7[/TD]
[TD="class: xl65, align: right"]5,643.1[/TD]
[TD="class: xl65, align: right"]24.0[/TD]
[TD="class: xl65, align: right"]5,667.1[/TD]
[TD="class: xl65, align: right"]184.2[/TD]
[TD="class: xl65, align: right"]2,055.3[/TD]
[TD="class: xl65, align: right"]2,239.5[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65, align: right"]20.2[/TD]
[TD="class: xl65, align: right"]0.0[/TD]
[TD="class: xl65, align: right"]20.2[/TD]
[TD="class: xl65, align: right"]1,556.0[/TD]
[TD="class: xl65, align: right"]1,556.0[/TD]
[TD="class: xl65, align: right"]1,822.0[/TD]
[TD="class: xl65, align: right"]2,268.9[/TD]
[TD="class: xl65, align: right"]4,090.9[/TD]
[TD="class: xl65, align: right"]3,427.6[/TD]
[TD="class: xl65, align: right"]1,177.1[/TD]
[TD="class: xl65, align: right"]4,604.7[/TD]

[TD="class: xl65"]Darkness[/TD]
[TD="class: xl65, align: right"]0.0[/TD]
[TD="class: xl65, align: right"]0.0[/TD]
[TD="class: xl65, align: right"]0.0[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65, align: right"]0.0[/TD]
[TD="class: xl65, align: right"]0.0[/TD]
[TD="class: xl65, align: right"]0.0[/TD]
[TD="class: xl65, align: right"]0.0[/TD]
[TD="class: xl65, align: right"]0.0[/TD]
[TD="class: xl65, align: right"]0.0[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65, align: right"]0.0[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65, align: right"]0.0[/TD]
[TD="class: xl65, align: right"]0.0[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65, align: right"]0.0[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65, align: right"]0.0[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65, align: right"]0.0[/TD]
[TD="class: xl65, align: right"]0.0[/TD]
[TD="class: xl65, align: right"]0.0[/TD]

[TD="class: xl65"]ParkingB[/TD]
[TD="class: xl65, align: right"]9,898.0[/TD]
[TD="class: xl65, align: right"]366.7[/TD]
[TD="class: xl65, align: right"]10,264.7[/TD]
[TD="class: xl65, align: right"]1,898.0[/TD]
[TD="class: xl65, align: right"]58,899.9[/TD]
[TD="class: xl65, align: right"]60,797.9[/TD]
[TD="class: xl65, align: right"]4,326.7[/TD]
[TD="class: xl65, align: right"]62,457.7[/TD]
[TD="class: xl65, align: right"]66,784.4[/TD]
[TD="class: xl65, align: right"]2,365.5[/TD]
[TD="class: xl65, align: right"]16,179.4[/TD]
[TD="class: xl65, align: right"]18,544.9[/TD]
[TD="class: xl65, align: right"]10,264.7[/TD]
[TD="class: xl65, align: right"]10,264.7[/TD]
[TD="class: xl65, align: right"]47,993.9[/TD]
[TD="class: xl65, align: right"]941.5[/TD]
[TD="class: xl65, align: right"]48,935.4[/TD]
[TD="class: xl65, align: right"]48,899.0[/TD]
[TD="class: xl65, align: right"]0.2[/TD]
[TD="class: xl65, align: right"]48,899.2[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65, align: right"]10,264.7[/TD]
[TD="class: xl65, align: right"]10,264.7[/TD]
[TD="class: xl65, align: right"]0.0[/TD]
[TD="class: xl65, align: right"]0.0[/TD]
[TD="class: xl65, align: right"]36,107.6[/TD]
[TD="class: xl65, align: right"]36,107.6[/TD]
[TD="class: xl65, align: right"]0.0[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65, align: right"]0.0[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65, align: right"]1,925.3[/TD]
[TD="class: xl65, align: right"]10,866.2[/TD]
[TD="class: xl65, align: right"]12,791.5[/TD]
[TD="class: xl65, align: right"]47,993.9[/TD]
[TD="class: xl65, align: right"]941.5[/TD]
[TD="class: xl65, align: right"]48,935.4[/TD]

[TD="class: xl65"]Grand Total[/TD]
[TD="class: xl65, align: right"]11,955.7[/TD]
[TD="class: xl65, align: right"]650.0[/TD]
[TD="class: xl65, align: right"]12,605.7[/TD]
[TD="class: xl65, align: right"]1,898.0[/TD]
[TD="class: xl65, align: right"]58,899.9[/TD]
[TD="class: xl65, align: right"]60,797.9[/TD]
[TD="class: xl65, align: right"]4,326.7[/TD]
[TD="class: xl65, align: right"]62,457.7[/TD]
[TD="class: xl65, align: right"]66,784.4[/TD]
[TD="class: xl65, align: right"]2,365.5[/TD]
[TD="class: xl65, align: right"]16,179.4[/TD]
[TD="class: xl65, align: right"]18,544.9[/TD]
[TD="class: xl65, align: right"]12,605.7[/TD]
[TD="class: xl65, align: right"]12,605.7[/TD]
[TD="class: xl65, align: right"]51,999.2[/TD]
[TD="class: xl65, align: right"]2,169.1[/TD]
[TD="class: xl65, align: right"]54,168.4[/TD]
[TD="class: xl65, align: right"]55,481.3[/TD]
[TD="class: xl65, align: right"]24.2[/TD]
[TD="class: xl65, align: right"]55,505.6[/TD]
[TD="class: xl65, align: right"]184.2[/TD]
[TD="class: xl65, align: right"]12,421.5[/TD]
[TD="class: xl65, align: right"]12,605.7[/TD]
[TD="class: xl65, align: right"]0.0[/TD]
[TD="class: xl65, align: right"]0.0[/TD]
[TD="class: xl65, align: right"]36,107.6[/TD]
[TD="class: xl65, align: right"]36,107.6[/TD]
[TD="class: xl65, align: right"]0.0[/TD]
[TD="class: xl65, align: right"]547.8[/TD]
[TD="class: xl65, align: right"]547.8[/TD]
[TD="class: xl65, align: right"]20.2[/TD]
[TD="class: xl65, align: right"]0.0[/TD]
[TD="class: xl65, align: right"]20.2[/TD]
[TD="class: xl65, align: right"]1,556.0[/TD]
[TD="class: xl65, align: right"]1,556.0[/TD]
[TD="class: xl65, align: right"]3,882.5[/TD]
[TD="class: xl65, align: right"]13,391.3[/TD]
[TD="class: xl65, align: right"]17,273.8[/TD]
[TD="class: xl65, align: right"]51,999.2[/TD]
[TD="class: xl65, align: right"]2,169.1[/TD]
[TD="class: xl65, align: right"]54,168.4[/TD]

</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
 
Sort by date Sort by votes
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).
 
Upvote 0
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!
 
Upvote 0
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.
 
Upvote 0
You must log in or register to reply here.

Similar threads

J
  • Question Question
pulling data from one chart to another
Replies
1
Views
834
jb00976
J
O
  • Question Question
Survey data to capture full month
Replies
5
Views
911
DanteAmor
DanteAmor
F
  • Question Question
Time Percentages
Replies
1
Views
926
James006
James006
M
  • Question Question
Finding value in a row
Replies
4
Views
1K
MRN227
M
C
  • Question Question
Sum
Replies
3
Views
1K
pbornemeier
pbornemeier

Share this page

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