Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Grouping Resource Tasks

Status
Not open for further replies.

Byebye14

Systems Engineer
Oct 8, 2020
1
US
Hey all,

I have a good brain teaser.. well at least I think it is. I am trying to build a view in my project file where I group my tasks by department. Here is the thing: I need to use the 'Resource Names' column which contains multiple departments per action.

So every task has an assigned department but also has several other departments that must touch that task before it can be completed. Example: Task 1, Dept-ENG, Resource Names-ENG,MFG,MSAT. Task 2, Dept-MFG, Resource Names-MFG,MSAT.

Basically, I need to show every task that each department touches. From the example from above I need the following results...

ENG
Task 1​
MFG
Task 1​
Task 2​
MSAT
Task 1​
Task 2​

I am not sure how to do this. When I groupby department it only returns the tasks with their respective department. Can someone help please??

Thank you!
 
Hi,

I'd EXPORT the related data or view as a text file that can be IMPORTED into Excel via Data > Get External Data > From Text Files... (NEVER open a text file using Excel. Rather IMPORT data into Excel and specify the Data Type of each column)

Then use Insert > Tables > PivotTables... to report the data in the desired format.

Get further help at Forum68.

Skip,
[sub]
[glasses]Just traded in my OLD subtlety...
for a NUance![tongue][/sub]
"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top