Merge cells

[#1]

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

[jjfabian]

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.

[#3]

hmm..i think you still using straight table not pivot table.

[#4]

Thanks , I have it now