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
![](../52slike/19_prikaz_razlicitih_formi_u_pivot_tabelama_141.jpg) |
![](../52slike/19_prikaz_razlicitih_formi_u_pivot_tabelama_142.jpg) |
Picture 2. SHOW IN COMPATCT FORM
|
Picture 3. SHOW IN OUTLINE FORM
|
|
|
![](../52slike/19_prikaz_razlicitih_formi_u_pivot_tabelama_144.jpg) |
![](../52slike/19_prikaz_razlicitih_formi_u_pivot_tabelama_143.jpg) |
Picture 4. SHOW IN TABULAR FORM
|
Picture 5. DO NOT REPEAT ITEM LABELS
|
![](19_prikaz_razlicitih_formi_u_pivot_tabelama_14.gif) |
Pivot Table Report Layout, steps:
- PIVOT TABLE TAB.
- DESIGN TAB.
- LAYOUT group.
- press on button Report Layout;
- Choose certain form;
- The end (Kraj).
N O T E:pivot tables can just be created from already existing files
Data for Creating pivot table 2
|
Index
|