FSG with transposed Revenues and Expenses????
Revenue Expenses
Dept 1 xxxx xxxx
2 xxxx xxxx
3 xxxx xxxx
n xxxx xxxx
Exp group 1 xxxx xxxx
Exp group 2 xxxx xxxx
Guys,
The above shell is the FSG i'm working on, where instead of having revenue/exp as rowsets they'll be shown as columnsets.
Dept 1 thru n... represent productlines(line of business). In addition I would like to remove some Expense account codes out of the column set and group them to represent exp groups and shown in rowsets.
I have managed to accomplish most of this FSG's components but I cannot get the removed expense accounts shown in the groupings(rowset) from appearing else where in the Dept 1 thru n (line of business).