Preparing Trial Balance Using Pivot Table

[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