{"id":163,"date":"2022-06-16T07:55:00","date_gmt":"2022-06-16T05:55:00","guid":{"rendered":"http:\/\/kalkulacija.com\/wordpress\/?p=163"},"modified":"2022-12-15T09:19:09","modified_gmt":"2022-12-15T08:19:09","slug":"izvedene-pivot-tabele","status":"publish","type":"post","link":"https:\/\/kalkulacija.com\/wordpress\/izvedene-pivot-tabele\/","title":{"rendered":"Kako napraviti izvedene (Pivot) tabele"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_83 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Sadr\u017eaj<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #0d590e;color:#0d590e\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #0d590e;color:#0d590e\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/kalkulacija.com\/wordpress\/power-pivot-tabele\/#Prednosti_power_pivot_tabele\" >Prednosti power pivot tabele<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/kalkulacija.com\/wordpress\/power-pivot-tabele\/#Priprema_podataka\" >Priprema podataka<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/kalkulacija.com\/wordpress\/power-pivot-tabele\/#Model_podataka\" >Model podataka<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/kalkulacija.com\/wordpress\/power-pivot-tabele\/#Uspostavljanje_relacija\" >Uspostavljanje relacija<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/kalkulacija.com\/wordpress\/power-pivot-tabele\/#Primena_DAX_formula\" >Primena DAX formula<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/kalkulacija.com\/wordpress\/power-pivot-tabele\/#Advantages_of_power_pivot_table\" >Advantages of power pivot table<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/kalkulacija.com\/wordpress\/power-pivot-tabele\/#Data_preparation\" >Data preparation<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/kalkulacija.com\/wordpress\/power-pivot-tabele\/#Data_model\" >Data model<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/kalkulacija.com\/wordpress\/power-pivot-tabele\/#Establishing_relationships\" >Establishing relationships<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/kalkulacija.com\/wordpress\/power-pivot-tabele\/#Application_of_DAX_formula\" >Application of DAX formula<\/a><\/li><\/ul><\/nav><\/div>\n<p><\/p>\r\n<p>Izvedene (Pivot) tabele omogu\u0107avaju sumiranje, prebrojavanje, \u00a0ili agregiranje podataka<a id=\"1\" href=\"#f1\"><sup>1<\/sup><\/a>\u00a0iz po\u010detne\/analiti\u010dke tabele. \u010cesto \u010dujemo ili ka\u017eemo \u201epivotiranje\u201c ili jo\u0161 gore, ajde \u201eispivotiraj\u201c mi tabelu.<\/p>\r\n<h2>\u010cemu slu\u017ee izvedene (Pivot) tabele<\/h2>\r\n<p>Re\u010d je o postupku grupisanja podataka po nekom kriterijumu i obavljanje naj\u010de\u0161\u0107e sabiranja ili neke druge matemati\u010dke operacije nad podacima iz po\u010detne tabele. Ta po\u010detna tabela \u010dije podatke \u017eelimo obraditi mo\u017ee biti u istoj ili nekoj datoteci koja je na disku ili deljenom folderu.<\/p>\r\n<p>Istorijski posmatrano <a href=\"https:\/\/en.wikipedia.org\/wiki\/Pivot_table\" target=\"_blank\" rel=\"noopener\">pivot tabele<\/a> <a href=\"https:\/\/en.wikipedia.org\/wiki\/Pivot_table\" target=\"_blank\" rel=\"noopener\">prema wikipediji<\/a> nastale su pre upotrebe ra\u010dunara u statistici u formi tabele broja pojavljivanja slu\u010dajeva, poznatije tabela distribucije pojavljivanja ili tabela frekvencije.<\/p>\r\n<p>U svojoj su\u0161tini, upotrebom izvedene (Pivot) tabele se mogu dobiti unakrsni iznosi, u stvari, broj komada ili zbir odre\u0111enih primeraka\/uzoraka.\u00a0 Kada je napravimo, tj. izvedemo taj postupak dobijamo\u00a0 nove informacije, koje mo\u017eemo raspore\u0111ivati na gotovo svaki mogu\u0107i na\u010din, i \u010dak uneti i nove matemati\u010dke formule sa kojima izra\u0111ujemo nova izra\u010dunavanja.<\/p>\r\n<h2><span style=\"color: #000000;\">Po\u010detna tabela izvor podataka<\/span><\/h2>\r\n<p><span style=\"color: #000000;\">Kada neke podatke evidentiramo u tabelama, za izradu izvedene tabele po\u017eeljno je da budu u obliku dvodimenzione tabele. <\/span><span style=\"color: #000000;\">U izvedenim tabelama numeri\u010dki podaci se sabiraju, a tekstualni se broje.<\/span><\/p>\r\n<p><span style=\"color: #000000;\">\r\n\r\n<\/span><\/p>\r\n<p><span style=\"color: #000000;\">\r\n\r\n<\/span><\/p>\r\n<p><span style=\"color: #000000;\">\r\n\r\n<\/span><\/p>\r\n<p><strong>Primer:<\/strong> Recimo da imamo evidenciju svih ra\u010duna u nekom poslovnom periodu, recimo od po\u010detka godine i \u017eelimo da saznamo koliko smo trebali da naplatimo po tim ra\u010dunima za svaki mesec od po\u010detka godine?<\/p>\r\n<p><span style=\"color: #000000;\">Po\u010detna dvodimenziona tabela sa podacima mo\u017ee da izgleda ovako:<\/span><\/p>\r\n<figure id=\"attachment_3130\" aria-describedby=\"caption-attachment-3130\" style=\"width: 671px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3130\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/01\/pivot-tabele-01.png\" alt=\"Pocetna tabela\" width=\"671\" height=\"271\" srcset=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/01\/pivot-tabele-01.png 671w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/01\/pivot-tabele-01-300x121.png 300w\" sizes=\"auto, (max-width: 671px) 100vw, 671px\" \/><figcaption id=\"caption-attachment-3130\" class=\"wp-caption-text\">Po\u010detna tabela za &#8220;pivotiranje&#8221;<\/figcaption><\/figure>\r\n<p><span style=\"color: #000000;\">\r\n\r\n<\/span><span style=\"color: #000000;\"><\/span><\/p>\r\n<p>Sada ve\u0107 se pitate \u0161ta je tu dvodimenziono, kada ima 8 kolona. Za detaljnije upoznavanje sa ovim pitanjem mo\u017eete pogledati na\u0161 tekst o tabelama u excel-u, ili jo\u0161 bolje \u010dlanak o inverznom postupku <a href=\"https:\/\/kalkulacija.com\/wordpress\/unpivot-tabele\/\">antipivotiranja<\/a>, kada iz izvedene tabele izra\u0111ujete po\u010detnu tabelu.<\/p>\r\n<h2><span style=\"color: #000000;\">Kreiranje ili izvo\u0111enje tabele<\/span><\/h2>\r\n<p>Ako ste otvorili <a href=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/05\/Tabela-svih-racuna.xlsx\" target=\"_blank\" rel=\"noopener\">excel tabelu<\/a> izaberite <strong>Insert<\/strong> i prvo dugme <strong>Pivot Table<\/strong> kao na slede\u0107oj slici.<\/p>\r\n<figure id=\"attachment_3141\" aria-describedby=\"caption-attachment-3141\" style=\"width: 678px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-3141 size-full\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/01\/pivot-tabele-02.png\" alt=\"Po\u010detna tabela za pivotiranje\" width=\"678\" height=\"357\" srcset=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/01\/pivot-tabele-02.png 678w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/01\/pivot-tabele-02-300x158.png 300w\" sizes=\"auto, (max-width: 678px) 100vw, 678px\" \/><figcaption id=\"caption-attachment-3141\" class=\"wp-caption-text\">Pokretanje izvo\u0111enja pivot tabele ili pivotiranje<\/figcaption><\/figure>\r\n<p><span style=\"color: #000000;\">Ova baza podataka sadr\u017ei veliku koli\u010dinu podataka, ali kao takva ne govori mnogo toga. Da bi podaci bili korisniji, moramo ih objedini, grupisati, dobiti zbirove i na taj na\u010din odgovoriti na neka pitanja:<\/span><\/p>\r\n<p><span style=\"color: #000000;\"><\/span><span style=\"color: #000000;\"><\/span><\/p>\r\n<ul class=\"wp-block-list\">\r\n<li><span style=\"color: #000000;\">Koliki je iznos ra\u010duna u svakoj filijali, podeljen prema vrsti ra\u010duna?<\/span><\/li>\r\n<li><span style=\"color: #000000;\">Koliko je ra\u010duna otvoreno u svakoj filijali, po vrstama ra\u010duna?<\/span><\/li>\r\n<li><span style=\"color: #000000;\">Koja expozitura otvara najvi\u0161e ra\u010duna novim strankama?<\/span><\/li>\r\n<\/ul>\r\n<p><span style=\"color: #000000;\"><\/span><span style=\"color: #000000;\"><\/span><\/p>\r\n<p><span style=\"color: #000000;\"><\/span><span style=\"color: #000000;\"><\/span><\/p>\r\n<p><span style=\"color: #000000;\">Na radnom listu odabrati bilo koju \u0107eliju, a zatim izabrati <strong>Insert\/Table\/PivotTable<\/strong>. Otvori\u0107e se slede\u0107i dijalog prozor:<\/span><\/p>\r\n<figure id=\"attachment_3159\" aria-describedby=\"caption-attachment-3159\" style=\"width: 466px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-3159 size-full\" title=\"Dijalog za pivotiranje\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/01\/pivot-tabele-03.png\" alt=\"Dijalog za pivotiranje\" width=\"466\" height=\"303\" srcset=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/01\/pivot-tabele-03.png 466w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/01\/pivot-tabele-03-300x195.png 300w\" sizes=\"auto, (max-width: 466px) 100vw, 466px\" \/><figcaption id=\"caption-attachment-3159\" class=\"wp-caption-text\">Dijalog za pivotiranje<\/figcaption><\/figure>\r\n<p><span style=\"color: #000000;\"><\/span><span style=\"color: #000000;\"><\/span><\/p>\r\n<p><span style=\"color: #000000;\"><\/span><\/p>\r\n<p><span style=\"color: #000000;\">U polju <strong>Tabel\/Range<\/strong> unesemo opseg \u0107elija po\u010detne table (slektujemo tabelu). Ukoliko koristimo podatke iz spolja\u0161nje datoteke, biramo opciju <strong>Use an external data source<\/strong>. <\/span><span style=\"color: #000000;\">U donjem delu dijalog prozora biramo mesto za izvedenu tabelu: postoje\u0107i ili novi radni list.<\/span><\/p>\r\n<p><span style=\"color: #000000;\"><\/span><span style=\"color: #000000;\"><\/span><\/p>\r\n<p><span style=\"color: #000000;\"><\/span><span style=\"color: #000000;\"><\/span><\/p>\r\n<p><span style=\"color: #000000;\">Nakon OK, Excel \u0107e napraviti praznu izvedenu tabelu i otvoriti okno <strong>PivoTable Field List<\/strong> (lista polja izvedene tabele), kao na slede\u0107oj slici:<\/span><\/p>\r\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-3160\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/01\/pivot-tabele-04.png\" alt=\"\" width=\"217\" height=\"381\" srcset=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/01\/pivot-tabele-04.png 217w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/01\/pivot-tabele-04-171x300.png 171w\" sizes=\"auto, (max-width: 217px) 100vw, 217px\" \/><\/p>\r\n<p><span style=\"color: #000000;\"><\/span><span style=\"color: #000000;\"><\/span><span style=\"color: #000000;\"><\/span><\/p>\r\n<p><span style=\"color: #000000;\"><strong>Raspore\u0111ivanje<\/strong> elemenata izvedene tabele \u2013 mo\u017eete koristiti slede\u0107e postupke:<\/span><\/p>\r\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-3161\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/01\/pivot-tabele-05.png\" alt=\"\" width=\"344\" height=\"625\" srcset=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/01\/pivot-tabele-05.png 344w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/01\/pivot-tabele-05-165x300.png 165w\" sizes=\"auto, (max-width: 344px) 100vw, 344px\" \/>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\u00a0<\/p>\r\n<p><span style=\"color: #000000;\"><\/span><span style=\"color: #000000;\"><\/span><\/p>\r\n<ul class=\"wp-block-list\">\r\n<li><span style=\"color: #000000;\">uklju\u010dite prekida\u010d pored stavke na vrhu okna, excel \u0107e to polje postaviti na jedno od \u010detiri polja u donjem delu okna<\/span><\/li>\r\n<\/ul>\r\n<p><span style=\"color: #000000;\"><\/span><span style=\"color: #000000;\"><\/span><\/p>\r\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-3162\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/01\/pivot-tabele-06.png\" alt=\"\" width=\"347\" height=\"502\" srcset=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/01\/pivot-tabele-06.png 347w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/01\/pivot-tabele-06-207x300.png 207w\" sizes=\"auto, (max-width: 347px) 100vw, 347px\" \/><\/p>\r\n<ul>\r\n<li><span style=\"color: #000000;\">prevucite imena polja (na vrhu) na praznu izvedenu tabelu na radnom listu<\/span><\/li>\r\n<li><span style=\"color: #000000;\">prevucite imena polja na jedno od \u010detiri polja u donjem delu okna Pivot Table Field List<\/span><\/li>\r\n<li><span style=\"color: #000000;\">desnim tasterom mi\u0161a pritisnite ime polja na vrhu okna Pivot Table Field List i iz priru\u010dnom menija odaberite njegovu lokaciju.<\/span><\/li>\r\n<\/ul>\r\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-3164\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/01\/pivot-tabele-08.png\" alt=\"\" width=\"452\" height=\"652\" srcset=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/01\/pivot-tabele-08.png 452w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/01\/pivot-tabele-08-208x300.png 208w\" sizes=\"auto, (max-width: 452px) 100vw, 452px\" \/><\/p>\r\n<p><span style=\"color: #000000;\">Ovim postupkom kreiramo tabelu, odre\u0111ujemo zbirove (ili neke druga izra\u010dunavanja) po kolonama i redovima, automatsko formatiranje, redosled pojavljivanja polja.<\/span><\/p>\r\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-3163\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/01\/pivot-tabele-07.png\" alt=\"\" width=\"244\" height=\"308\" srcset=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/01\/pivot-tabele-07.png 244w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/01\/pivot-tabele-07-238x300.png 238w\" sizes=\"auto, (max-width: 244px) 100vw, 244px\" \/><\/p>\r\n<p><span style=\"color: #000000;\"><\/span><span style=\"color: #000000;\"><\/span><\/p>\r\n<h3><span style=\"color: #000000;\"><strong>Najva\u017eniji pojmovi izvedenih (Pivot) tabela<\/strong><\/span><\/h3>\r\n<p><span style=\"color: #000000;\"><\/span><span style=\"color: #000000;\"><\/span><\/p>\r\n<ul class=\"wp-block-list\">\r\n<li><span style=\"color: #000000;\">Oznaka kolone \u2013 <strong>Column label<\/strong>-polje koja odre\u0111uju kolone sme\u0161taju se u zaglavlju tabele kao kolone.<\/span><\/li>\r\n<li><span style=\"color: #000000;\">Oznake redova- <strong>Row labels<\/strong>&#8211; polja koje odre\u0111uju redove u izvedenoj tabeli<\/span><\/li>\r\n<li><span style=\"color: #000000;\">Ukupni zbir- <strong>Grand total<\/strong> \u2013 red ili kolona u kojima se prikazuje ukupan zbir<\/span><\/li>\r\n<li><span style=\"color: #000000;\">Me\u0111uzbir \u2013 <strong>Subtotal<\/strong> \u2013 red ili kolona sa prikazanim me\u0111uzbirovima<\/span><\/li>\r\n<li><span style=\"color: #000000;\">Osve\u017eavanje \u2013 <strong>Refresh<\/strong> \u2013 a\u017euriranje zbirova nakon izmene izvornih podataka<\/span><\/li>\r\n<li><span style=\"color: #000000;\">Filter tabele \u2013 <strong>Table filter<\/strong> \u2013 polje po kom se izdvajaju podaci<\/span><\/li>\r\n<li><span style=\"color: #000000;\">Stavka \u2013<strong>Item<\/strong>&#8211; elementi polja \u2013 npr polje je Vrsta ra\u010duna, stavke su \u0161tednja, teku\u0107i i \u017eiro-ra\u010dun<\/span><\/li>\r\n<\/ul>\r\n<h2><strong>Formatiranje ili ure\u0111enje izvedene (pivot) tabele<\/strong><\/h2>\r\n<p>Sada kada je izvedena pivot tabela, obratite pa\u017enju na novu traku sa alatima. Pojavila su se dva dela <strong>Analyze<\/strong> i <strong>Design<\/strong>.<\/p>\r\n<figure id=\"attachment_3187\" aria-describedby=\"caption-attachment-3187\" style=\"width: 337px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3187\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/01\/pivot-tabele-09.png\" alt=\"Ure\u0111enje izvedene tabele\" width=\"337\" height=\"170\" srcset=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/01\/pivot-tabele-09.png 337w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/01\/pivot-tabele-09-300x151.png 300w\" sizes=\"auto, (max-width: 337px) 100vw, 337px\" \/><figcaption id=\"caption-attachment-3187\" class=\"wp-caption-text\">Ure\u0111enje izvedene tabele<\/figcaption><\/figure>\r\n<p>Na traci <strong>Analyze<\/strong> (Analiziraj) mo\u017eete formatirati podatke u tabeli u delu <strong>Active Fieald<\/strong>, npr. nov\u010dane iznose u format sa dve decimale, itd. ili da a\u017eurirate podatke za obra\u010dun u delu<strong> Data<\/strong> na <strong>Refresh<\/strong> dugme.<\/p>\r\n<p>Na traci <strong>Design<\/strong> (Dizajn) pored stila prikazivanja tabele, mo\u017eete izabrati i elemente koji \u0107e biti prikazani.<\/p>\r\n<h2><strong>Agregiranje podataka<\/strong><\/h2>\r\n<p>One kolone \u010dije vrednosti \u017eelimo agregirati (grupisati) i izra\u010dunati, brebrojati, itd. prevucimo u okno <strong>Value<\/strong> (vrednosti).<\/p>\r\n<figure id=\"attachment_3188\" aria-describedby=\"caption-attachment-3188\" style=\"width: 257px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-3188\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/01\/pivot-tabele-10.png\" alt=\"Agregiranje\" width=\"257\" height=\"381\" srcset=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/01\/pivot-tabele-10.png 257w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/01\/pivot-tabele-10-202x300.png 202w\" sizes=\"auto, (max-width: 257px) 100vw, 257px\" \/><figcaption id=\"caption-attachment-3188\" class=\"wp-caption-text\">Agregiranje<\/figcaption><\/figure>\r\n<p>Levim klikom na kolonu u pomo\u0107nom meniju izaberite <strong>Value field settings,<\/strong> mo\u017eete izabrati matemati\u010dku funkciju kojim \u0107ete obraditi podatke, npr. sabiranje iznosa funkcijom <strong>SUM<\/strong>, prebojte iznose funkcijom <strong>COUNT<\/strong>, izra\u010dunajte srednju vrednost funkcijom <strong>AVERAGE<\/strong>, prika\u0111ite najve\u0107u vrednost\u00a0 funkcijom <strong>MAX<\/strong>, itd.<\/p>\r\n<h2><strong>Izrada kalkulativnih kolona<\/strong><\/h2>\r\n<p>U slu\u010daju kada imate potrebu da izra\u010dunate nove vrednosti u izvedenoj tabeli, a takva kolona ne postoji u po\u010detnoj tabeliNa traci <strong>Analyze<\/strong> (Analiziraj) mo\u017eete formatirati podatke u tabeli u delu <strong>Active Fieald<\/strong>, npr. nov\u010dane iznose u format sa dve decimale, itd. ili da a\u017eurirate podatke za obra\u010dun u delu<strong> Data<\/strong> na <strong>Refresh<\/strong> dugme.Dopuna je u toku.<\/p>\r\n<h2><strong>Grupisanje podataka &#8211; izrada stratuma<\/strong><\/h2>\r\n<p>Ako \u017eelite da grupi\u0161ete neke redove tabele, kliknite desnim tasterom na jednu ili onoliko vrednosti u prvoj koloni, koliko \u017eelite da grupi\u0161ete i iz pomo\u0107nog menija izaberite opciju <strong>Group<\/strong>.<\/p>\r\n<h2><strong>Filtriranje i slajsovanje podataka<\/strong><\/h2>\r\n<p>U oknu <strong>Filters<\/strong> mo\u017eemo prevu\u0107i \u017eeljenu kolonu koja proizvodi novi red iznad pivot tabele, omogu\u0107avaju\u0107i korisniku da filtrira rezultate u tabeli.<\/p>\r\n<figure id=\"attachment_3186\" aria-describedby=\"caption-attachment-3186\" style=\"width: 553px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-3186 size-full\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/01\/pivot-tabele-13.png\" alt=\"Filtriranje i slajsovanje podataka\" width=\"553\" height=\"844\" srcset=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/01\/pivot-tabele-13.png 553w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/01\/pivot-tabele-13-197x300.png 197w\" sizes=\"auto, (max-width: 553px) 100vw, 553px\" \/><figcaption id=\"caption-attachment-3186\" class=\"wp-caption-text\">Filtriranje i slajsovanje podataka<\/figcaption><\/figure>\r\n<h2><strong>Snimak postupka izvo\u0111enja izve\u0161tajne tabele<\/strong><\/h2>\r\n<p>Kada pokrenemo Excel program mo\u017eemo pristupiti raznim templejtima i preuzeti i instrukcije o radu sa izvedenim (pivot) tabelama \u0161to smo dali na snimku. Iz datog primera \u0107ete videti tipi\u010dan slu\u010daj kada mo\u017eete izvesti tabelu sa novim agregiranim podacima. Recimo da imamo evidenciju (tabelu)\u00a0 tro\u0161kova jedne porodice. Kog datuma koji \u010dlan \u0161ta je kupovao i koliko je potro\u0161io.\u00a0<strong><em>\u00a0\u00a0<\/em><\/strong><\/p>\r\n<p><iframe loading=\"lazy\" title=\"izvedene tabele\" width=\"840\" height=\"630\" src=\"https:\/\/www.youtube.com\/embed\/4m59i4vq2zw?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen><\/iframe><\/p>\r\n<h3>Izvori<\/h3>\r\n<p><a id=\"f1\" href=\"#1\"><sup>1<\/sup><\/a> Wikipedija \u010dlanak o etimolo\u0161kom zna\u010denju re\u010di agregacija https:\/\/en.wiktionary.org\/wiki\/aggregatus#Latin<\/p>\r\n<p>&nbsp;<\/p>\r\n<p><span style=\"color: #000000;\">\r\n\r\n<\/span><\/p>\r\n<p><strong>Pogledajte jo\u0161:<\/strong><\/p>\r\n<hr \/>\r\n\n\n<div class=\"su-posts su-posts-default-loop \">\n\n\t\n\t\t\t\t\t\n\t\t\t\n\t\t\t<div id=\"su-post-913\" class=\"su-post \">\n\n\t\t\t\t\t\t\t\t\t<a class=\"su-post-thumbnail\" href=\"https:\/\/kalkulacija.com\/wordpress\/power-pivot-tabele\/\"><img loading=\"lazy\" decoding=\"async\" width=\"209\" height=\"140\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2021\/06\/power-e1624192014714.png\" class=\"attachment-post-thumbnail size-post-thumbnail wp-post-image\" alt=\"\" \/><\/a>\n\t\t\t\t\n\t\t\t\t<h2 class=\"su-post-title\"><a href=\"https:\/\/kalkulacija.com\/wordpress\/power-pivot-tabele\/\">Prava mo\u0107 Power pivot tabele<\/a><\/h2>\n\n\t\t\t\t<div class=\"su-post-meta\">\n\t\t\t\t\tPosted: 13\/06\/2022\t\t\t\t<\/div>\n\n\t\t\t\t<div class=\"su-post-excerpt\">\n\t\t\t\t\t<p>Power pivot (unapre\u0111ena izvedena) tabela obuhvata postupak izrade izve\u0161tajne tabele veoma sli\u010dan Pivot tabeli, \u010dija je osnovna prednost agregiranje\/grupisanje podataka<\/p>\n\t\t\t\t<\/div>\n\n\t\t\t\t\n\t\t\t<\/div>\n\n\t\t\n\t\n<\/div>\n\r\n<hr \/>\r\n<p>&nbsp;<\/p>\n\n<div class=\"kk-star-ratings kksr-auto kksr-align-right kksr-valign-bottom\"\n    data-payload='{&quot;align&quot;:&quot;right&quot;,&quot;id&quot;:&quot;913&quot;,&quot;slug&quot;:&quot;default&quot;,&quot;valign&quot;:&quot;bottom&quot;,&quot;ignore&quot;:&quot;&quot;,&quot;reference&quot;:&quot;auto&quot;,&quot;class&quot;:&quot;&quot;,&quot;count&quot;:&quot;1&quot;,&quot;legendonly&quot;:&quot;&quot;,&quot;readonly&quot;:&quot;&quot;,&quot;score&quot;:&quot;5&quot;,&quot;starsonly&quot;:&quot;&quot;,&quot;best&quot;:&quot;5&quot;,&quot;gap&quot;:&quot;5&quot;,&quot;greet&quot;:&quot;Ocenite post&quot;,&quot;legend&quot;:&quot;5\\\/5 - (1 vote)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;Prava mo\u0107 Power pivot tabele&quot;,&quot;width&quot;:&quot;142.5&quot;,&quot;_legend&quot;:&quot;{score}\\\/{best} - ({count} {votes})&quot;,&quot;font_factor&quot;:&quot;1.25&quot;}'>\n            \n<div class=\"kksr-stars\">\n    \n<div class=\"kksr-stars-inactive\">\n            <div class=\"kksr-star\" data-star=\"1\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"2\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"3\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"4\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"5\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n    \n<div class=\"kksr-stars-active\" style=\"width: 142.5px;\">\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n<\/div>\n                \n\n<div class=\"kksr-legend\" style=\"font-size: 19.2px;\">\n            5\/5 - (1 vote)    <\/div>\n    <\/div>","protected":false},"excerpt":{"rendered":"<p>Izvedene (Pivot) tabele omogu\u0107avaju sumiranje, prebrojavanje, \u00a0ili agregiranje podataka1\u00a0iz po\u010detne\/analiti\u010dke tabele. \u010cesto \u010dujemo ili ka\u017eemo \u201epivotiranje\u201c ili jo\u0161 gore, ajde<\/p>\n","protected":false},"author":1,"featured_media":923,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[42,45,19],"tags":[],"class_list":["post-163","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-napredni-excel","category-pivot-tabele","category-ekscel"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Izvedene (Pivot) tabele<\/title>\n<meta name=\"description\" content=\"Izvedene (Pivot) tabele omogu\u0107avaju sumiranje, prebrojavanje ili agregiranje podataka iz po\u010detne\/analiti\u010dke tabele tabele.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/kalkulacija.com\/wordpress\/izvedene-pivot-tabele\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Izvedene (Pivot) tabele\" \/>\n<meta property=\"og:description\" content=\"Izvedene (Pivot) tabele omogu\u0107avaju sumiranje, prebrojavanje ili agregiranje podataka iz po\u010detne\/analiti\u010dke tabele tabele.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kalkulacija.com\/wordpress\/izvedene-pivot-tabele\/\" \/>\n<meta property=\"og:site_name\" content=\"Kalkulacija u osnovi svega!\" \/>\n<meta property=\"article:published_time\" content=\"2022-06-16T05:55:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-12-15T08:19:09+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/pwp1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"840\" \/>\n\t<meta property=\"og:image:height\" content=\"562\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/izvedene-pivot-tabele\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/izvedene-pivot-tabele\\\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\"},\"headline\":\"Kako napraviti izvedene (Pivot) tabele\",\"datePublished\":\"2022-06-16T05:55:00+00:00\",\"dateModified\":\"2022-12-15T08:19:09+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/izvedene-pivot-tabele\\\/\"},\"wordCount\":2318,\"publisher\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\"},\"image\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/izvedene-pivot-tabele\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2017\\\/09\\\/pwp1.png\",\"articleSection\":[\"Napredni Excel\",\"Pivot tabele\",\"Poslovni Excel\"],\"inLanguage\":\"sr-SR\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/izvedene-pivot-tabele\\\/\",\"url\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/izvedene-pivot-tabele\\\/\",\"name\":\"Izvedene (Pivot) tabele\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/izvedene-pivot-tabele\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/izvedene-pivot-tabele\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2017\\\/09\\\/pwp1.png\",\"datePublished\":\"2022-06-16T05:55:00+00:00\",\"dateModified\":\"2022-12-15T08:19:09+00:00\",\"description\":\"Izvedene (Pivot) tabele omogu\u0107avaju sumiranje, prebrojavanje ili agregiranje podataka iz po\u010detne\\\/analiti\u010dke tabele tabele.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/izvedene-pivot-tabele\\\/#breadcrumb\"},\"inLanguage\":\"sr-SR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/izvedene-pivot-tabele\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"sr-SR\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/izvedene-pivot-tabele\\\/#primaryimage\",\"url\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2017\\\/09\\\/pwp1.png\",\"contentUrl\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2017\\\/09\\\/pwp1.png\",\"width\":840,\"height\":562,\"caption\":\"power pivot\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/izvedene-pivot-tabele\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Kako napraviti izvedene (Pivot) tabele\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#website\",\"url\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/\",\"name\":\"Kalkulacija u osnovi svega!\",\"description\":\"Samo napred! Unapredite svoje ve\u0161tine obrade podataka!\",\"publisher\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"sr-SR\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"sr-SR\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/Excel-icon.png\",\"url\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/Excel-icon.png\",\"contentUrl\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/Excel-icon.png\",\"width\":128,\"height\":128,\"caption\":\"admin\"},\"logo\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/Excel-icon.png\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Izvedene (Pivot) tabele","description":"Izvedene (Pivot) tabele omogu\u0107avaju sumiranje, prebrojavanje ili agregiranje podataka iz po\u010detne\/analiti\u010dke tabele tabele.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/kalkulacija.com\/wordpress\/izvedene-pivot-tabele\/","og_locale":"en_US","og_type":"article","og_title":"Izvedene (Pivot) tabele","og_description":"Izvedene (Pivot) tabele omogu\u0107avaju sumiranje, prebrojavanje ili agregiranje podataka iz po\u010detne\/analiti\u010dke tabele tabele.","og_url":"https:\/\/kalkulacija.com\/wordpress\/izvedene-pivot-tabele\/","og_site_name":"Kalkulacija u osnovi svega!","article_published_time":"2022-06-16T05:55:00+00:00","article_modified_time":"2022-12-15T08:19:09+00:00","og_image":[{"width":840,"height":562,"url":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/pwp1.png","type":"image\/png"}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin","Est. reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/kalkulacija.com\/wordpress\/izvedene-pivot-tabele\/#article","isPartOf":{"@id":"https:\/\/kalkulacija.com\/wordpress\/izvedene-pivot-tabele\/"},"author":{"name":"admin","@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4"},"headline":"Kako napraviti izvedene (Pivot) tabele","datePublished":"2022-06-16T05:55:00+00:00","dateModified":"2022-12-15T08:19:09+00:00","mainEntityOfPage":{"@id":"https:\/\/kalkulacija.com\/wordpress\/izvedene-pivot-tabele\/"},"wordCount":2318,"publisher":{"@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4"},"image":{"@id":"https:\/\/kalkulacija.com\/wordpress\/izvedene-pivot-tabele\/#primaryimage"},"thumbnailUrl":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/pwp1.png","articleSection":["Napredni Excel","Pivot tabele","Poslovni Excel"],"inLanguage":"sr-SR"},{"@type":"WebPage","@id":"https:\/\/kalkulacija.com\/wordpress\/izvedene-pivot-tabele\/","url":"https:\/\/kalkulacija.com\/wordpress\/izvedene-pivot-tabele\/","name":"Izvedene (Pivot) tabele","isPartOf":{"@id":"https:\/\/kalkulacija.com\/wordpress\/#website"},"primaryImageOfPage":{"@id":"https:\/\/kalkulacija.com\/wordpress\/izvedene-pivot-tabele\/#primaryimage"},"image":{"@id":"https:\/\/kalkulacija.com\/wordpress\/izvedene-pivot-tabele\/#primaryimage"},"thumbnailUrl":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/pwp1.png","datePublished":"2022-06-16T05:55:00+00:00","dateModified":"2022-12-15T08:19:09+00:00","description":"Izvedene (Pivot) tabele omogu\u0107avaju sumiranje, prebrojavanje ili agregiranje podataka iz po\u010detne\/analiti\u010dke tabele tabele.","breadcrumb":{"@id":"https:\/\/kalkulacija.com\/wordpress\/izvedene-pivot-tabele\/#breadcrumb"},"inLanguage":"sr-SR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kalkulacija.com\/wordpress\/izvedene-pivot-tabele\/"]}]},{"@type":"ImageObject","inLanguage":"sr-SR","@id":"https:\/\/kalkulacija.com\/wordpress\/izvedene-pivot-tabele\/#primaryimage","url":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/pwp1.png","contentUrl":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/pwp1.png","width":840,"height":562,"caption":"power pivot"},{"@type":"BreadcrumbList","@id":"https:\/\/kalkulacija.com\/wordpress\/izvedene-pivot-tabele\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/kalkulacija.com\/wordpress\/"},{"@type":"ListItem","position":2,"name":"Kako napraviti izvedene (Pivot) tabele"}]},{"@type":"WebSite","@id":"https:\/\/kalkulacija.com\/wordpress\/#website","url":"https:\/\/kalkulacija.com\/wordpress\/","name":"Kalkulacija u osnovi svega!","description":"Samo napred! Unapredite svoje ve\u0161tine obrade podataka!","publisher":{"@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/kalkulacija.com\/wordpress\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"sr-SR"},{"@type":["Person","Organization"],"@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4","name":"admin","image":{"@type":"ImageObject","inLanguage":"sr-SR","@id":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/05\/Excel-icon.png","url":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/05\/Excel-icon.png","contentUrl":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/05\/Excel-icon.png","width":128,"height":128,"caption":"admin"},"logo":{"@id":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/05\/Excel-icon.png"}}]}},"_links":{"self":[{"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/posts\/163","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/comments?post=163"}],"version-history":[{"count":81,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/posts\/163\/revisions"}],"predecessor-version":[{"id":3690,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/posts\/163\/revisions\/3690"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/media\/923"}],"wp:attachment":[{"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/media?parent=163"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/categories?post=163"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/tags?post=163"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}