N
noelaprospero
Hi.
I need to prepare an excel report, with information on who does what. I use
the assignment usage template provided within visual reports. The problem is
that y have a very huge project and need to filter tasks that are already
completed.
When editing the template I found there were very few dimensions to be used
as filters in the resulting pivot table.
i decided to use the "Is marked" dimension.
Inside the project I ran a macro that marks as "yes" for pending tasks (when
% Work Complete es less than 100%).
When I run the report the filter does not work.
The behaviour is bizarre ineed. For example, if I use the Task Usage
templates, if I include the ISMarked Dimensions, only tasks markes as "Yes"
are included in the resulting Pivot table. This is exactly what I need. But
for the Assignment usage template, though the IsMared dimension es available,
it is not working at all.
(By the way, as I said before, my real problem, is filtering the assignment
usage excel visual report by Incomplete tasks. If problem with IsMarked has
no solution, but you know a way to help me with my real needs, I´d be equally
thankful)
I need to prepare an excel report, with information on who does what. I use
the assignment usage template provided within visual reports. The problem is
that y have a very huge project and need to filter tasks that are already
completed.
When editing the template I found there were very few dimensions to be used
as filters in the resulting pivot table.
i decided to use the "Is marked" dimension.
Inside the project I ran a macro that marks as "yes" for pending tasks (when
% Work Complete es less than 100%).
When I run the report the filter does not work.
The behaviour is bizarre ineed. For example, if I use the Task Usage
templates, if I include the ISMarked Dimensions, only tasks markes as "Yes"
are included in the resulting Pivot table. This is exactly what I need. But
for the Assignment usage template, though the IsMared dimension es available,
it is not working at all.
(By the way, as I said before, my real problem, is filtering the assignment
usage excel visual report by Incomplete tasks. If problem with IsMarked has
no solution, but you know a way to help me with my real needs, I´d be equally
thankful)