I'm trying to build a pivot table that looks like this what is below. But I'm having a hard time nesting fields in the underlying table in a way that produces this result, any help would be much appreciated.
*the % values are what that fund is charging in fees.
background: manager requested a tool to track fees by account AND time for 135 funds. Except some funds send data monthly, some quarterly, some semi annually, some annually 
This is all sample data.
One twist is that the table that feeds the pivot table will have different times at which data is updated, so Fund 1 might be updated in April for months Jan-Mar and Fund 2 might be updated in January for months Jan-Dec. I'm hoping to (1) figure out a way to "export" the values to a kind of repository and (2) select individual funds to be included for a period (for example, have the pivot table only include funds that were updated for the first quarter). [TABLE="border: 1, cellpadding: 1, width: 500"]
[TABLE="border: 0, cellpadding: 0, cellspacing: 0, width: 553"]
Period
Fund
Details
Account A
Account B
Account C
Account D
Fund 1
1.25%
Market Values
50,000
200,000
1,000,000
150,000
Calculated Fee
625
2,500
12,500
1,875
Actual Fee
1,000
2,000
13,000
1,000
Difference
(375)
500
(500)
875
Fund 2
2.00%
Market Values
2,000,000
1,800,000
700,000
500,000
Calculated Fee
40,000
36,000
14,000
10,000
Actual Fee
40,000
36,000
15,000
8,000
Difference
-
-
(1,000)
2,000
Portfolio Totals
Market Values
2,050,000
2,000,000
1,700,000
650,000
Calculated Fee
40,625
38,500
26,500
11,875
Actual Fee
41,000
38,000
28,000
9,000
Difference
(375)
500
(1,500)
2,875
[/TABLE]
[/TABLE]