Pivot Table Field Labels

[cazzzac]

Hi there,

Is there any way to display the field labels in a column next to the PivotTable data?

I currently have a contruction project database that I am displaying in a pivot table; however, the table only displays the raw data with no data labels (e.g. project commencement date, project completion date, project city are displayed as 20/03/13, 31/01/14, Melbourne).


For useability i want it to be displayed as:

1. Column A, Row 1: Project commencement date
   1. Column B, Row 1: 20/03/13
2. Column A, Row 2: Project completion date:
   1. Column B, Row 2: 31/01/14
3. Column A, Row 3: Project City
   1. Column B, Row 3: Melbourne

Rather than just the Column B information.

Is there any way to achieve this with Pivot Tables?