abc MICROSOFT EXCEL 2010 - Pivot table
Display subtotals in pivot table /SUBTOTALS/

 

Picture 1. One variable for rows

Picture 2. Two variables for rows
   

Picture 3. SUBTOTAL on top of the group

Picture 4. SUBTOTAL at the bottom
 

display subtotals in pivot table /SUBTOTALS/,procedure:

  1. PIVOT TABLE TAB.
  2. DESIGN TAB.
  3. LAYOUT group.
  4. press on button Subtotals;
  5. In sliding menu choose certain option;
  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