| July | August | September | October | November | December | January | Feburary | March | April | May | June | RACCT | RYEAR |
| (3,702,016,744) | - | (4,043,495,249) | (3,919,571,587) | (4,456,645,062) | (5,338,085,126) | - | - | - | - | - | - | EAB004 | 2014 |
| (4,277,644,535) | - | (4,007,338,712) | (63,365,813) | - | (4,850,234,029) | (3,906,747,463) | (5,236,924,186) | (5,032,595,880) | - | (3,958,259,939) | - | EAB004 | 2015 |
Dear All,
I have the objective of representing my account information in the form of a P&L statement with the heads, Revenue, Expenditure and so on. These heads are comprised of different accounts stored in the ledger. The accounts can be identified using the RACCT coloumn as shown in the data. The problem I am facing is that i need to show current month and year to Month coloums for each P&L head in the dashboard. Since the monthly transaction data is stored in coloumns as shown in the table above I am unable to calculate the year to date and current month since I do not know how to perform calculations on coloumns. Please help in this regards.
Just to clarify there are multiple rows for each RACCT for each month and there is another Year coloumn in the data for year.
Regards,
Ali Haider
