1.

How Do You Make Two Data Fields Appear Side-by-side, Instead Of In Separate Rows?

Answer»

After adding the two fields to the pivot table's data area, DRAG the Data field button to the right, onto the cell that contains the word 'Total'. There's a PICTURE here that shows the 'Total' cell.

  • CHANGE pivot table data to horizontal layout.And to keep related data from spreading horizontally off of the screen and to help minimize scrolling,click Show in Compact Form.
  • In compact form, fields are CONTAINED in one column and indented to show the nested column relationship.
  • To outline the data in the classic PivotTable style, click Show in Outline Form.
  • To see all data in a traditional table format and to EASILY copy cells to another worksheet, click Show in Tabular Form.

After adding the two fields to the pivot table's data area, drag the Data field button to the right, onto the cell that contains the word 'Total'. There's a picture here that shows the 'Total' cell.


Discussion

No Comment Found

Related InterviewSolutions