Summarize a worksheet by two sets of values?

[cberg]

Can a worksheet be summarized by two columns of values?  For example, I would like to first organize my worksheet by department, which I have put in the "Occupant Type" Field.  And then summarize the items by the custom space name.  

 

I want the worksheet to communicate the following:

 

• In the RH Regional Group, there are “x”   6’ x 8’ cubes.  
• In the R2 Homes Group, there are “y”   6’ x 8’ cubes.  

 

In that way, one can review the building program by department. 

 

I know I can make separate worksheets for department and summarize the values.  Is there a way to build these worksheets into a master worksheet? Or is there another way to do this?

 

 

[Pat Stanford]

You can SUMmarize on multiple columns. When you add the first SUMmarization (Department in your case) it will collapse everything into a single subrow by the values in that column.

 

When you then add a SUMmarization to the second column (space name) it kind of does an "unsumarization" and will then show a subrow for each unique value for Spacename in each Department.

 

It is easier to do than to explain.

 

Try it and ask again if you still need help.

[cberg]

That's exactly what I needed, thank you.