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:
Rather than just the Column B information.
Is there any way to achieve this with Pivot Tables?
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:
- Column A, Row 1: Project commencement date
- Column B, Row 1: 20/03/13
- Column A, Row 2: Project completion date:
- Column B, Row 2: 31/01/14
- Column A, Row 3: Project City
- Column B, Row 3: Melbourne
Rather than just the Column B information.
Is there any way to achieve this with Pivot Tables?