I am creating a pivot table with source sheet as follows:
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
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>
</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
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