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
[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