field calculation in a 3 dimensional pivot table

**Shimoe** · 03-11-2009, 09:00 AM

Maybe someone can help me with this one.

I would like to create a pivot table in which i would like to compare spendings against a preseted plan for various categories and the subsegments of each category.

To do this I intended to add a manual field calculation which subtracts the actual spendings against the plan. Now when I inserted the calculation my pivot table reflects all subsegments for each category. Is there a way to avoid this artificial blow up?

**malnahar** · 03-11-2009, 10:31 AM

Hi,

Can you please attach a sample of the workbook?

Thanks

**mrblack12** · 01-16-2013, 09:22 AM

Hi,
I'm having a similar challenge: trying to create a pivot table from a number of sheets, all with the same layout. When I do this for two dimensions (e.g. project and activity) it works fine, but when I try to add a third dimension, team member, the values won't add up, all it shows are zero's (see attachment).

Basically, what I'm trying to do is make a report of the hours spent by my teammembers on activities within projects. They register their hours in a sheet with columns "Date", "Project". "Task" and "Hours".

Am desperately looking for help!

Cheers,
Rick
Sources.jpg Pivot tables.jpg

**arlu1201** · 01-16-2013, 09:35 AM

Rick,

Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.