battlingwithexcel
Board Regular
- Joined
- Dec 22, 2011
- Messages
- 82
Hi there,
I have a pivot table laid out similar to the below....the values in the columns represent aged debt and basically I need to identify which debt is 'new' i.e. appears in column 01/13 but not in 12/12 column (items in red), and which debt has been paid i.e. appeared in 12/12 column but is absent in 01/2013 column (items in green).
I need to be able to do this on a regular basis each week and compare the relevant list of debt with the previous week. Therefore ideally, I would like to be able to have a pivot table showing only the red and green items so I can easily double click on the totals to drill down to the list of invoices falling into each category...(each week I need to compile a list of paid and new debt). I can manually do this by clicking on the individual items but it is taking me SO long as there are tons of invoices to cross-check....
Can anyone help?
<TBODY>
</TBODY>
I have a pivot table laid out similar to the below....the values in the columns represent aged debt and basically I need to identify which debt is 'new' i.e. appears in column 01/13 but not in 12/12 column (items in red), and which debt has been paid i.e. appeared in 12/12 column but is absent in 01/2013 column (items in green).
I need to be able to do this on a regular basis each week and compare the relevant list of debt with the previous week. Therefore ideally, I would like to be able to have a pivot table showing only the red and green items so I can easily double click on the totals to drill down to the list of invoices falling into each category...(each week I need to compile a list of paid and new debt). I can manually do this by clicking on the individual items but it is taking me SO long as there are tons of invoices to cross-check....
Can anyone help?
Sum of Total | ||
12/2012 | 01/2013 | |
3</SPAN> | £31,163</SPAN> | £31,163</SPAN> |
4 | £52,399 | |
5</SPAN> | £52,399</SPAN> | |
6 | £64,708 | £64,708 |
7</SPAN> | £64,708</SPAN> | £64,708</SPAN> |
8 | £627,517 | £627,517 |
9</SPAN> | £627,517</SPAN> | £627,517</SPAN> |
10 | £19,766</SPAN> | |
11 | £101,584 | £101,584 |
12</SPAN> | £47,189</SPAN> | £47,189</SPAN> |
13</SPAN> | £20,718</SPAN> | </SPAN> |
14</SPAN> | £33,677</SPAN> |
<TBODY>
</TBODY>