Preparing Trial Balance Using Pivot Table

[Zaigham]

Hi everybody,

Is it possible to prepare a trial balance from a given data table by using Pivot table? For example I have hundreds of records under the fields as described below:
Month, Formation, Act_Code, Debit and Credit.

Can I get the results as mentioned below:
Trial Balance of a selected formation, upto a specific period i.e., Formation A's trial balance for April 2013. The table is required as below:
1. Act_code,
2. Op Balance Dr/(Cr) (Sum of figures upto March 2013),
3. DEBIT (Sum of figures incorporated during the month April),
4. CREDIT (Sum of figures incorporated during the month April),
5. DEBIT (Progressive net figures upto April 2013), and
6. CREDIT (Progressive net figures upto April 2013).

I have prepared the above table by using various excel formulas but I want to get this table by using "Pivot Table". Is it doable?

Regards
Zaigham

[Excel Fox]

Can you post a sample with the input data and expected output data? If the file size is over limit, try uploading it to a fileshare site, and post the link here.

[Zaigham]

Can you post a sample with the input data and expected output data? If the file size is over limit, try uploading it to a fileshare site, and post the link here.

Sample file is attached. I have pasted the values instead of formulas. However, this output I want through pivot table.
Thanks a lot.

Regards
Zaigham

[Excel Fox]

Most of the subtotal shown doesn't make sense. Here's the closest I could reach.

[Zaigham]

Hi,


Sub totals are not important, so I have removed them from file. By using Pivot table I get sum of expense of only 01 criteria, whereas I want 03 different projections at a time i.e.

1. Sum of expense up to Feb in 01 Col. (Dr.+Cr) or may be separately as Opening Balance.
2. Sum of expense only for March. (For expense incorporated during the month)
3. Sum of expense up to March (as year to date) net of which come whether debit or credit.

Hope I have explained more clearly.

Regards
Zaigham