abc MICROSOFT EXCEL 2010 - Pivot table
Pivot Table Report Layout

In pivot table there are multiple ways of pivot table layout /PIVOT TABLE REPORT LAYOUT/. From PIVOT TABLE TAB, choose DESIGN TABand from LAYOUT group choose REPORT LAYOUT button.


Picture 1. REPORT LAYOUT dugeme

Picture 2. SHOW IN COMPATCT FORM

Picture 3. SHOW IN OUTLINE FORM

   

Picture 4. SHOW IN TABULAR FORM

Picture 5. DO NOT REPEAT ITEM LABELS

 

Pivot Table Report Layout, steps:

  1. PIVOT TABLE TAB.
  2. DESIGN TAB.
  3. LAYOUT group.
  4. press on button Report Layout;
  5. Choose certain form;
  6. The end (Kraj).

N O T E:pivot tables can just be created from already existing files
Data for Creating pivot table 2

 Index