Resource Charts - filtering & Summary

Member for

19 years 11 months

Say you have 3 buildings.

Just delete all of the resources for 2 of them (ctrl-D) from a blank cell) directly in the Resource Names column of the Entry Table. Then run/print the graph etc in Resource Graph View, then close the file, don’t save, re-open and do the same for the other buildings.

Or save the Resource Names column in a spare text column so you can copy/paste to and from it so you don’t have to close and re-open.

This might seem clumsy but should work.

Member for

17 years 4 months

Trevor



Thanks for your quick response - tried it doesnt work! the filtering obviously does, but the resources are still for the whole project and I can only view them individually not as a whole or summary no. of men. Thanks for trying though



Regards



Andrew


Member for

19 years 11 months

Since you need it quick, here it is rough and not checked.

Easiest way to separate the buildings is to use a spare Text field and just fill in the field with ctrl-D (fill down) Building 1, Building 2 etc, then make a filter (Project, Filtered For etc) which reads the field.

I think that if you filter out the buildings you don’t want and then go to the Resource sheet, Resource graph etc, you should get the graphs just for the building that the filter brings back. Not sure, not checked.