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.
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.
