Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I everyone, I use a pivot table which shows planned hours on projects. Resources spend hours on the projects.
For example; this is how it shows now:
Now it looks like there are 172 hours planned on this projects for both resources someone1 and someone2.
I would like it to look like this (this is Excel):
How do I achieve something like this so it shows the planned hours of 172 for this project not per resource?
Thanks
If you use your planned hours as a dimension, you should be able to pivotize it. Use a pivot table instead of a straight table.
hmm..i think you still using straight table not pivot table.
Thanks , I have it now