I have a pivot table in an Excel 2007 which contains information about debts. On the left side, the table shows states and their villages. When these data are coalesced or expanded the debts in the pivot table are shown in the correct way since the stateīs debt is the addition of all its villages’ debts.
At the top of the table I need to put information about when debts occur. I want to put three levels: year, quarter and month. But in this case when the information is coalesced o expanded it isnīt showed in a correct way because the year debt is equal to Decemberīs debt, a quarterīs debt is equal to last month of the quarterīs debt.
I canīt use none accumulative predefined functions because this behavior canīt be implemented not with sum, nor with max,…..

How can I simulate this behavior?
Thank in advance.