Hi all,
Please help me in implementing a table such as below.-
The first row is the sum(allocation) amount for individual months, dimension name to be given(not coming from database) ALLOCATION(synthetic).
The next rows are the sum(BALANCE) per DIVISION, for each month.
| Division | MONTH | 1 | 2 | 3 | 4 |
| ALLOCATION |
| 0.4 | 0.4 | 0.4 | 0.4 |
| DIV1 |
| 600000 | 160000 | 750000 | 1410000 |
| DIV2 |
| 800000 | 150000 | 910000 | 900000 |
| DIV4 |
| 100000 | 30000 | 100000 | 370000 |
| DIV3 |
| 200000 | 20000 | 450000 | 380000 |
| DIV5 |
| 400000 | 40000 | 900000 | 760000 |
| DIV6 |
| 200000 | 20000 | 450000 | 380000 |
sample dats is attached herewith.
Thanks,
Sonika
