P
patemarie
I have a view in Portfolio Analyzer that depicts resources in the rows,
projects they are associated with in the rows (per resource), and then
columns showing Work and Availability that can be filtered using the Time
fields. The issue that prior to SP2a the Projects field only showed projects
the resource was associated with. Post SP2a, this view is now showing all
Open Projects for every resource. With that said, the view is now huge and
is more than what is needed. We only need projects associated with a
resource. We export this view into Excel for reporting purposes. Any
suggestions on how to manipulate the pivot table to only show projects
associated with each resource? I've tried everything!
projects they are associated with in the rows (per resource), and then
columns showing Work and Availability that can be filtered using the Time
fields. The issue that prior to SP2a the Projects field only showed projects
the resource was associated with. Post SP2a, this view is now showing all
Open Projects for every resource. With that said, the view is now huge and
is more than what is needed. We only need projects associated with a
resource. We export this view into Excel for reporting purposes. Any
suggestions on how to manipulate the pivot table to only show projects
associated with each resource? I've tried everything!