E
EESweet
Hi All,
I'm using the Visual Reports feature in MS Project that produces
reports based on Excel pivot tables connected to cubes produced by
Project. I know that when using a cube as the data source I
(unfortunately) cannot use a calculated field, so I'm trying to change
the Value Field Setting instead, but the result is always the same, it
just produces #N/A.
In Project, I've selected to use the Assignment Usage cube. In Excel
I have made the following selections:
Row Label = Resources
Column Labels = Values
Values = Baseline Work, Actual Work
What I'm trying to do is display Actual Work as the % Difference From
from Baseline Work. However when I try this, or Difference From, % Of
it displays #N/A. When I do % of Row, it shows 100%, even though it
isn't. Am I doing something wrong, or is this just not possible?
Sample Row
Resource Baseline Work Actual Work
Adam 415 315
Thanks for any help, this is driving me a little crazy since it seems
like this would be a great use of the feature, if it worked!
Eric
I'm using the Visual Reports feature in MS Project that produces
reports based on Excel pivot tables connected to cubes produced by
Project. I know that when using a cube as the data source I
(unfortunately) cannot use a calculated field, so I'm trying to change
the Value Field Setting instead, but the result is always the same, it
just produces #N/A.
In Project, I've selected to use the Assignment Usage cube. In Excel
I have made the following selections:
Row Label = Resources
Column Labels = Values
Values = Baseline Work, Actual Work
What I'm trying to do is display Actual Work as the % Difference From
from Baseline Work. However when I try this, or Difference From, % Of
it displays #N/A. When I do % of Row, it shows 100%, even though it
isn't. Am I doing something wrong, or is this just not possible?
Sample Row
Resource Baseline Work Actual Work
Adam 415 315
Thanks for any help, this is driving me a little crazy since it seems
like this would be a great use of the feature, if it worked!
Eric