Summing all values from a certain date

[juliorevka]

I have three account types (Student, Departmental, and CC). On a fiscal month, each has a certain amount of counts per fee type. I want to find the total number of items among the three account types.

For example:
On July 2006,
The "Student Account" has 437 "Items Deposited"


The "Dept. Account" has 2,691 "Items Deposited"
The "CC Account" has 0 "Items Deposited"

I want to find the sum of these three (3128). I have 102 different months and 7 types of fees onto which I need to do this.

Any help?

[orange]

Please show your table design(s).

[juliorevka]

The file is too large and the info is confidential. But basically,

Table DimAccounts
AccKey AccName
1_______Student
2_______Dept
3_______CC

Table DimDate
DateKey FiscalDate
1_______Jul '03
2_______Aug '03
3_______Oct 03
etc. etc

Table FeeType
FeeType FeeDesc
1_______Items Deposited
2_______Returned Items
3_______Overdraft
etc. etc

Table DimFees
FeeKey AccKey DateKey FeeTypeKey ItemCount FeePerItem
1_______1_______1_______1__________600________$0
2_______1_______1_______2__________200________$2
3_______1_______1_______3__________400________$3
etc.

[juliorevka]

Any help??