G/ L individual account

hi guys,

my analysis view g/l account is set as a range of g/l acc no. eg: (1000…3000|5000…5500),

i would like to find in individual account balance amount



furthermore i would like to break down into columns for particular account no.


g/l acc. division1 division2
1000 $250 $200
2000 $500 $23

You would need to do this using an Account Schedule rather than an Analysis view.
There you can set the dimension totaling filter on the columns as well, giving you a column per division.

hi thomas,

you are absolutely right, in account schedule line totaling account, bold, underline everything is being input and just set range the amount according to the totaling account number, dimension that we want…and the value would be there [:)]