Most of the subtotal shown doesn't make sense. Here's the closest I could reach.
Most of the subtotal shown doesn't make sense. Here's the closest I could reach.
A dream is not something you see when you are asleep, but something you strive for when you are awake.
It's usually a bad idea to say that something can't be done.
The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve
Join us at Facebook
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
Posting Permissions
Reply With Quote
Bookmarks