mlmoyer
New Member
- Joined
- Sep 25, 2008
- Messages
- 15
I have a data table that looks somewhat like this a number of rows of "Date", "ID#" and other extraneous fields.
I have a pivot table that simply lists the total count by date, then i grouped it by month and then by quarter:
<table x:str="" style="border-collapse: collapse; width: 220pt;" border="0" cellpadding="0" cellspacing="0" width="293"><col style="width: 69pt;" width="92"> <col style="width: 43pt;" span="2" width="57"> <col style="width: 65pt;" width="87"> <tbody><tr style="height: 13.5pt;" height="18"> <td style="height: 13.5pt; width: 69pt;" width="92" height="18">
</td> <td style="width: 43pt;" width="57">
</td> <td style="width: 43pt;" width="57">
</td> <td style="width: 65pt;" width="87">
</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl22" style="height: 15.75pt;" height="21">Date4</td> <td class="xl23">Date2</td> <td class="xl23">Date</td> <td class="xl26">Count of ID</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17">2008-Q4</td> <td class="xl28"> </td> <td class="xl28"> </td> <td class="xl24" x:num="" align="right">76</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl29" style="height: 12.75pt;" height="17"> </td> <td class="xl33" colspan="2" style="">October 2008</td> <td class="xl32" x:num="" align="right">29</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl29" style="height: 12.75pt;" height="17"> </td> <td class="xl31">
</td> <td class="xl30" x:num="39722">10/1/08</td> <td class="xl25" x:num="" align="right">8</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl29" style="height: 12.75pt;" height="17"> </td> <td class="xl31">
</td> <td class="xl30" x:num="39736">10/15/08</td> <td class="xl25" x:num="" align="right">19</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl29" style="height: 12.75pt;" height="17"> </td> <td class="xl31">
</td> <td class="xl30" x:num="39742">10/21/08</td> <td class="xl25" x:num="" align="right">1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl29" style="height: 12.75pt;" height="17"> </td> <td class="xl31">
</td> <td class="xl30" x:num="39752">10/31/08</td> <td class="xl25" x:num="" align="right">1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl29" style="height: 12.75pt;" height="17"> </td> <td class="xl31">
</td> <td class="xl31">
</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl29" style="height: 12.75pt;" height="17"> </td> <td class="xl33" colspan="2" style="">November 2008</td> <td class="xl32" x:num="" align="right">25</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl29" style="height: 12.75pt;" height="17"> </td> <td class="xl31">
</td> <td class="xl30" x:num="39753">11/1/08</td> <td class="xl25" x:num="" align="right">2</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl29" style="height: 12.75pt;" height="17"> </td> <td class="xl31">
</td> <td class="xl30" x:num="39767">11/15/08</td> <td class="xl25" x:num="" align="right">19</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl29" style="height: 12.75pt;" height="17"> </td> <td class="xl31">
</td> <td class="xl30" x:num="39773">11/21/08</td> <td class="xl25" x:num="" align="right">1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl29" style="height: 12.75pt;" height="17"> </td> <td class="xl31">
</td> <td class="xl30" x:num="39781">11/29/08</td> <td class="xl25" x:num="" align="right">2</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl29" style="height: 12.75pt;" height="17"> </td> <td class="xl31">
</td> <td class="xl30" x:num="39782">11/30/08</td> <td class="xl25" x:num="" align="right">1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl29" style="height: 12.75pt;" height="17"> </td> <td class="xl31">
</td> <td class="xl31">
</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl29" style="height: 12.75pt;" height="17"> </td> <td class="xl33" colspan="2" style="">December 2008</td> <td class="xl32" x:num="" align="right">22</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl29" style="height: 12.75pt;" height="17"> </td> <td class="xl31">
</td> <td class="xl30" x:num="39783">12/1/08</td> <td class="xl25" x:num="" align="right">1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl29" style="height: 12.75pt;" height="17"> </td> <td class="xl31">
</td> <td class="xl30" x:num="39797">12/15/08</td> <td class="xl25" x:num="" align="right">19</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl29" style="height: 12.75pt;" height="17"> </td> <td class="xl31">
</td> <td class="xl30" x:num="39803">12/21/08</td> <td class="xl25" x:num="" align="right">1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl29" style="height: 12.75pt;" height="17"> </td> <td class="xl31">
</td> <td class="xl30" x:num="39813">12/31/08</td> <td class="xl25" x:num="" align="right">1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl29" style="height: 12.75pt;" height="17"> </td> <td class="xl31">
</td> <td class="xl31">
</td> <td>
</td> </tr> </tbody></table>
My problem is, when i add a new row to the main table, say with a date of "December 20, 2008", and refresh the pivot table, the information ends up clear at the bottom (in this case, after the year 2014).
What am I doing wrong? I figured the pivot refresh would place the data among the other December 2008 rows in the pivot table.
Thanks.
Mark
I have a pivot table that simply lists the total count by date, then i grouped it by month and then by quarter:
<table x:str="" style="border-collapse: collapse; width: 220pt;" border="0" cellpadding="0" cellspacing="0" width="293"><col style="width: 69pt;" width="92"> <col style="width: 43pt;" span="2" width="57"> <col style="width: 65pt;" width="87"> <tbody><tr style="height: 13.5pt;" height="18"> <td style="height: 13.5pt; width: 69pt;" width="92" height="18">
</td> <td style="width: 43pt;" width="57">
</td> <td style="width: 43pt;" width="57">
</td> <td style="width: 65pt;" width="87">
</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl22" style="height: 15.75pt;" height="21">Date4</td> <td class="xl23">Date2</td> <td class="xl23">Date</td> <td class="xl26">Count of ID</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17">2008-Q4</td> <td class="xl28"> </td> <td class="xl28"> </td> <td class="xl24" x:num="" align="right">76</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl29" style="height: 12.75pt;" height="17"> </td> <td class="xl33" colspan="2" style="">October 2008</td> <td class="xl32" x:num="" align="right">29</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl29" style="height: 12.75pt;" height="17"> </td> <td class="xl31">
</td> <td class="xl30" x:num="39722">10/1/08</td> <td class="xl25" x:num="" align="right">8</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl29" style="height: 12.75pt;" height="17"> </td> <td class="xl31">
</td> <td class="xl30" x:num="39736">10/15/08</td> <td class="xl25" x:num="" align="right">19</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl29" style="height: 12.75pt;" height="17"> </td> <td class="xl31">
</td> <td class="xl30" x:num="39742">10/21/08</td> <td class="xl25" x:num="" align="right">1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl29" style="height: 12.75pt;" height="17"> </td> <td class="xl31">
</td> <td class="xl30" x:num="39752">10/31/08</td> <td class="xl25" x:num="" align="right">1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl29" style="height: 12.75pt;" height="17"> </td> <td class="xl31">
</td> <td class="xl31">
</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl29" style="height: 12.75pt;" height="17"> </td> <td class="xl33" colspan="2" style="">November 2008</td> <td class="xl32" x:num="" align="right">25</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl29" style="height: 12.75pt;" height="17"> </td> <td class="xl31">
</td> <td class="xl30" x:num="39753">11/1/08</td> <td class="xl25" x:num="" align="right">2</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl29" style="height: 12.75pt;" height="17"> </td> <td class="xl31">
</td> <td class="xl30" x:num="39767">11/15/08</td> <td class="xl25" x:num="" align="right">19</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl29" style="height: 12.75pt;" height="17"> </td> <td class="xl31">
</td> <td class="xl30" x:num="39773">11/21/08</td> <td class="xl25" x:num="" align="right">1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl29" style="height: 12.75pt;" height="17"> </td> <td class="xl31">
</td> <td class="xl30" x:num="39781">11/29/08</td> <td class="xl25" x:num="" align="right">2</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl29" style="height: 12.75pt;" height="17"> </td> <td class="xl31">
</td> <td class="xl30" x:num="39782">11/30/08</td> <td class="xl25" x:num="" align="right">1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl29" style="height: 12.75pt;" height="17"> </td> <td class="xl31">
</td> <td class="xl31">
</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl29" style="height: 12.75pt;" height="17"> </td> <td class="xl33" colspan="2" style="">December 2008</td> <td class="xl32" x:num="" align="right">22</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl29" style="height: 12.75pt;" height="17"> </td> <td class="xl31">
</td> <td class="xl30" x:num="39783">12/1/08</td> <td class="xl25" x:num="" align="right">1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl29" style="height: 12.75pt;" height="17"> </td> <td class="xl31">
</td> <td class="xl30" x:num="39797">12/15/08</td> <td class="xl25" x:num="" align="right">19</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl29" style="height: 12.75pt;" height="17"> </td> <td class="xl31">
</td> <td class="xl30" x:num="39803">12/21/08</td> <td class="xl25" x:num="" align="right">1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl29" style="height: 12.75pt;" height="17"> </td> <td class="xl31">
</td> <td class="xl30" x:num="39813">12/31/08</td> <td class="xl25" x:num="" align="right">1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl29" style="height: 12.75pt;" height="17"> </td> <td class="xl31">
</td> <td class="xl31">
</td> <td>
</td> </tr> </tbody></table>
My problem is, when i add a new row to the main table, say with a date of "December 20, 2008", and refresh the pivot table, the information ends up clear at the bottom (in this case, after the year 2014).
What am I doing wrong? I figured the pivot refresh would place the data among the other December 2008 rows in the pivot table.
Thanks.
Mark