Hi all,
we need solution on below mentioned issue. Attached file for your reference.
Issue :
1. 1. User enters end date in input box
2. 2. Based on that end date written formula to arrive the correct closing balances.
3. And we want to show another table last six months closing balances as showed below but unable to arrive month wise for the same
MONTH_NAME | Category | B | E | R | T | S | Total |
Jan 2014 | | 2,241,252 | 230,890,138 | 93,599,127 | 2,777,919 | 41,431 | 329,549,867 |
Dec 2013 | | 2,237,296 | 219,561,433 | 95,542,465 | 3,138,738 | 41,431 | 320,521,362 |
Nov 2013 | | 2,276,603 | 214,331,505 | 87,356,592 | 2,744,862 | 41,431 | 306,750,994 |
Oct 2013 | | 2,338,107 | 212,351,117 | 84,776,745 | 3,503,767 | 42,030 | 303,011,765 |
Sep 2013 | | 2,264,170 | 209,458,750 | 84,666,242 | 3,031,464 | 42,030 | 299,462,656 |
Aug 2013 | | 2,291,017 | 209,975,734 | 92,491,299 | 3,996,015 | 42029.6 | 308,796,094 |