I want inputform in the format which i have attached to this discussion . i have activities Activity1 and Activity2 and 7 accounts, against each activity i want to display line items of all accounts.
and finally i want to display total ie(total=activity1+activity2) against all accounts.
For getting more clarity please check the attached excel sheet in which i have given example by posting values
Note: total and total account line items should be calculated on the fly.