abc MICROSOFT EXCEL 2010 - Pivot table
Creating pivot table - deviding years and months

For data create Pivot table :Collom godina,row prodavaci and ostvareni iznos .Pivot table is created just like in the photo


Picture 1. Prikaz po godinama

Creating pivot table - deviding years and months, steps:

  1. Select data;
  2. INSERT TAB:
  3. PIVOT TABLE button:
  4. choose range .
  5. Choose place of displaying pivot table.
  6. OK button
  7. Choose date and amount .
  8. right click .
  9. choose GROUP option
  10. ROW field now contains YEARS (Years) and MONTHS (mjesece).
  11. leave just YEARS.
  12. The end (Kraj).

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

 Index