Consolidatd pivot

[bt-psmith]

I am having trouble getting my consolidated pivot to reflect all the data fields I need. Instead I am getting just row, column, data and page. Below is a sample of the data that I am trying to consolidate.

Project 1

Name Position Project # Apr-07 Mar-07
John Art Project 1 10 5
Mary Art Project 1 5 5
James Design Project 1 5 5
Steve Programming Project 1 5 5


Project 2

Name Position Project # Apr-07 Mar-07
John Art Project 2 5 5
Mary Art Project 2 10 5
James Design Project 2 10 10
Steve Programming Project 2 10 10


Project 3

Name Position Project # Apr-07 Mar-07
John Art Project 3 5 5
Mary Art Project 3 10 5
James Design Project 3 10 10
Steve Programming Project 3 10 10




I need a pivot that looks like this:
Name Position Project # Apr-07 Mar-07
John Art Project 1 10 5
Project 2 5 5
Project 3 5 5
John total 20 15