abc MICROSOFT EXCEL 2010 - Pivot table
Choosing final number of all Rows-Colloms /GRAND TOTAL/

Picture 1. Without GRAND TOTAL data

Picture 2. GRAND TOTAL right /ON THE ROWS ONLY/
   

Picture 3. GRAND TOTAL down /ON THE OLUMNS ONLY/

Picture 4. GRAND TOTAL right and down /ON THE ROWS and THE COLUMNS/

 

Choosing final number of all Rows-Colloms /GRAND TOTAL/, steps:

  1. PIVOT TABLE TAB.
  2. DESIGN TAB.
  3. LAYOUT group.
  4. GRAND TOTALS button;
  5. In sliding menu choose certain option;
  6. The end (Kraj).

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

 index