abc MICROSOFT EXCEL 2010 - Pivot table
Creating pivot table - Years

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


Picture 1. Prodavači i porizvodi po godinama

Creating pivot table - Years, 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. Add prodavače
  13. The end (Kraj).

N O T E:pivot tables can just be created from already existing files
Data forCreating pivot table 1

 Index