I hava spreadsheet that contains the following data:
Customer, Invoice, Project_Num, Project Mgr, invoince Amount.



every row in the project_num field contains the value of 1. This so when I create my pivot table I can sum this field for a total number of intoices per project manager as well as total of invoice amounts.

After creating the pivot table it shows the data as follows:

Project_Mgr SumOfProjects:
SumOf Inoices:

Is it possible for it to show the summary information horizontally instead of vertically?

Project_Mgr SumOfPorjects SumOfInvoices

Also, once I close the windows that displays the PivotTableFields I can not figure out how to get it back?

Can anyone help?