- Mark as New
- Follow
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report
Hi,
I would give each cell in a row a name in the hierarchy view. Then apply that name in each row.
The row total is Formcalc and is:
salaries + benefits + service + computerSoft + computerHard + travel
Then the column total uses the fact that the row names are the same (Row1), FormCalc:
$ = Sum(Row1[*].salaries[*])
I would right align the currency cells.
Hope that helps,
Niall
...snap...