How do I create meta-layered spreadsheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JTodd - 27 Mar 2008 13:28 GMT

I need to create a spreadsheet that looks like a meta-layer tree. The first
column will be departments, and then should expand to include the people in
that department. I need to be able to keep the departments in order and the
people in order within each department with additional columns for totals.
The first column is the only one that needs to be "expandable" though.
Please help, I have no idea how to make this work. Thanks!

Reply to this Message

Kevin B - 27 Mar 2008 14:18 GMT

Enter the data row by row and then sort on the Department column. Then use
subtotaling to generate the outline by department. You can use the Count
function as the summary function and count the number of employees per
department.

Signature

Kevin Backmann

> I need to create a spreadsheet that looks like a meta-layer tree. The first
> column will be departments, and then should expand to include the people in
> that department. I need to be able to keep the departments in order and the
> people in order within each department with additional columns for totals.
> The first column is the only one that needs to be "expandable" though.
> Please help, I have no idea how to make this work. Thanks!

Reply to this Message

JTodd - 27 Mar 2008 14:23 GMT

I just figured out the group by row function, and that seems to be working.
Thanks for the response.

> Enter the data row by row and then sort on the Department column. Then use
> subtotaling to generate the outline by department. You can use the Count
[quoted text clipped - 7 lines]
> > The first column is the only one that needs to be "expandable" though.
> > Please help, I have no idea how to make this work. Thanks!

Reply to this Message