blublublub
New Member
- Joined
- Mar 12, 2015
- Messages
- 1
Hi, i'm having trouble reconciling the following data sets. Basically I have 2 sheets and needs reconciling. I have done a pivot table to make reconciliation easier but run into trouble when i add more criterias.
Filter criteria as follows:
1st sheet: Filter Y (N/Y), I (I/E) - 2nd sheet: Filter Y (N/Y)
Sum Values through all time period (D1-D7) of each individual asset and portfolio
e.g. Asset (AAA), PF (1) = Value (57) should match with the same sum on sheet 2.
The number of portfolios and asset classes are alot.
I dont need an exact answer... just need ideas on how to approach or simplify this.... thanks in advance
1st sheet
<colgroup><col width="64" span="6" style="width:48pt"> </colgroup><tbody>
</tbody>
2nd sheet
<colgroup><col width="64" span="5" style="width:48pt"> </colgroup><tbody>
</tbody>
Filter criteria as follows:
1st sheet: Filter Y (N/Y), I (I/E) - 2nd sheet: Filter Y (N/Y)
Sum Values through all time period (D1-D7) of each individual asset and portfolio
e.g. Asset (AAA), PF (1) = Value (57) should match with the same sum on sheet 2.
The number of portfolios and asset classes are alot.
I dont need an exact answer... just need ideas on how to approach or simplify this.... thanks in advance
1st sheet
Portfolio2 | Asset2 | Time2 | Value2 | N/Y | I/E |
1 | AAA | D1 | 23 | Y | I |
1 | AAA | D3 | 32 | Y | I |
1 | AAA | D7 | 2 | Y | I |
2 | AAA | D2 | 52 | Y | I |
3 | AAA | D3 | 5 | N | I |
3 | AAA | D7 | 2 | Y | I |
4 | AAA | D7 | 1230 | Y | I |
5 | AAA | D1 | 23 | N | I |
5 | AAA | D2 | 2 | Y | I |
11 | AAA | D1 | 2 | Y | I |
12 | AAA | D1 | 31 | Y | I |
1 | CCC | D1 | 4 | Y | I |
2 | CCC | D2 | 24 | Y | I |
3 | CCC | D1 | 46 | Y | I |
3 | CCC | D7 | 9 | Y | I |
1 | DDD | D1 | 12 | Y | I |
2 | DDD | D7 | 2 | Y | E |
4 | DDD | D1 | 34 | N | I |
5 | DDD | D7 | 4 | Y | I |
<colgroup><col width="64" span="6" style="width:48pt"> </colgroup><tbody>
</tbody>
2nd sheet
Portfolio | Asset | Time | Value | Y/N |
1 | AAA | D1 | 23 | Y |
1 | AAA | D3 | 32 | Y |
1 | AAA | D7 | 2 | Y |
2 | AAA | D2 | 52 | Y |
3 | AAA | D3 | 5 | N |
3 | AAA | D7 | 2 | Y |
4 | AAA | D7 | 123 | Y |
5 | AAA | D1 | 23 | N |
5 | AAA | D2 | 2 | Y |
1 | CCC | D1 | 4 | Y |
2 | CCC | D2 | 24 | Y |
3 | CCC | D1 | 46 | Y |
3 | CCC | D7 | 9 | Y |
1 | DDD | D1 | 12 | Y |
2 | DDD | D7 | 2 | Y |
4 | DDD | D1 | 34 | N |
5 | DDD | D7 | 4 | Y |
<colgroup><col width="64" span="5" style="width:48pt"> </colgroup><tbody>
</tbody>