Resource view by row on sheet

We have a sheet in which we track the various projects on which our team is working. Is there a way to use resource planning to see what is making up the % allocation value in the resource view. 

For example, what I see now is this:

What I want to see when I expand each name is the projects on the sheet that make up the allocation percent.

Is that possible without creating a separate sheet for each project (the sheets would have one line each which seems silly).

Thanks much,

Andrea

Andrea Zenner

Program Manager | Infrastructure & Operations

Apogee Enterprises

EAP | Mobilizer | Core Product Certified | Superstar

azenner@apog.com

Answers