{"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\/en\/izvedene-pivot-tabele\/","title":{"rendered":"How to create Pivot Table"},"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\">Contents<\/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\/en\/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\/en\/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\/en\/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\/en\/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\/en\/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\/en\/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\/en\/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\/en\/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\/en\/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\/en\/power-pivot-tabele\/#Application_of_DAX_formula\" >Application of DAX formula<\/a><\/li><\/ul><\/nav><\/div>\n<p><\/p>\r\n<p><span class=\"\">Derived (Pivot) tables allow summarizing, counting, or aggregating data\u00a0<\/span><a id=\"1\" href=\"https:\/\/kalkulacija.com\/wordpress\/izvedene-pivot-tabele\/?preview=true#f1\"><sup><span class=\"\">1<\/span><\/sup><\/a><span class=\"\"> \u00a0from the initial\/analytical table. <\/span>We often hear or say &#8220;pivoting&#8221; or worse, let&#8217;s &#8220;pivot&#8221; my table.<\/p>\r\n<h2><span id=\"Cemu_sluze_izvedene_Pivot_tabele\" class=\"ez-toc-section\"><\/span>What are the pivot tables for?<\/h2>\r\n<p>It is a procedure of grouping data according to some criteria and performing the most common collection or some other mathematical operation on the data from the initial table.\u00a0The initial table whose data we want to process can be in the same or a file that is on a disk or shared folder.<\/p>\r\n<p>Historically\u00a0<a href=\"https:\/\/en.wikipedia.org\/wiki\/Pivot_table\" target=\"_blank\" rel=\"noopener\">, pivot tables\u00a0<\/a><a href=\"https:\/\/en.wikipedia.org\/wiki\/Pivot_table\" target=\"_blank\" rel=\"noopener\">according to wikipedia<\/a>\u00a0were created before the use of computers in statistics in the form of a table of the number of occurrences of cases, better known as the table of distribution of occurrences or tables of frequency.<\/p>\r\n<p>In essence, by using a derived (Pivot) table, cross-amounts can be obtained, in fact, the number of pieces or the sum of certain specimens \/ samples.\u00a0When we make it, ie.\u00a0we perform this procedure and get new information, which we can arrange in almost every possible way, and even enter new mathematical formulas with which we make new calculations.<\/p>\r\n<h2><span id=\"Pocetna_tabela_izvor_podataka\" class=\"ez-toc-section\"><\/span>Home table data source<\/h2>\r\n<p>When we record some data in tables, for the creation of a derived table, it is desirable that they be in the form of a two-dimensional table.\u00a0In the derived tables, numerical data are collected and textual ones are counted.<\/p>\r\n<p><strong>Example:<\/strong>\u00a0Let&#8217;s say we have a record of all accounts in a business period, say from the beginning of the year, and we want to know how much we should have charged on those accounts for each month since the beginning of the year?<\/p>\r\n<p>The initial two-dimensional data table might look like this:<\/p>\r\n<figure id=\"attachment_3130\" class=\"wp-caption alignnone\" aria-describedby=\"caption-attachment-3130\"><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\" sizes=\"auto, (max-width: 671px) 100vw, 671px\" 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\" alt=\"Starting table\" width=\"671\" height=\"271\" \/>\r\n<figcaption id=\"caption-attachment-3130\" class=\"wp-caption-text\">Starting table for \u201cpivoting\u201d<\/figcaption>\r\n<\/figure>\r\n<figure class=\"wp-block-image alignnone zoooom wp-image-164 size-full\">\r\n<figcaption><\/figcaption>\r\n<\/figure>\r\n<p>Now you are already wondering what is two-dimensional, when there are 8 columns.\u00a0For a more detailed acquaintance with this issue, you can see our text on tables in excel, or even better, the article on the inverse\u00a0<a href=\"https:\/\/kalkulacija.com\/wordpress\/unpivot-tabele\/\">antipivot<\/a>\u00a0procedure , when you create an initial table from the derived table.<\/p>\r\n<h2><span id=\"Kreiranje_ili_izvodenje_tabele\" class=\"ez-toc-section\"><\/span>Creating or executing a table<\/h2>\r\n<p>If you have opened an\u00a0<a href=\"https:\/\/kalkulacija.com\/wordpress\/?ed=download&amp;guid=ozlbyq-pgusml-sbtywa-lrokmu-qkzgus--uvnfxr-tlvbzr-yedomg-mteuqx-chwmnt\" target=\"_blank\" rel=\"noopener\">excel spreadsheet<\/a>\u00a0, select\u00a0<strong>Insert and the first\u00a0<\/strong><strong>Pivot Table<\/strong>\u00a0button\u00a0as in the following image.<\/p>\r\n<figure id=\"attachment_3141\" class=\"wp-caption alignnone\" aria-describedby=\"caption-attachment-3141\"><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\" sizes=\"auto, (max-width: 678px) 100vw, 678px\" 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\" alt=\"Initial pivoting table\" width=\"678\" height=\"357\" \/>\r\n<figcaption id=\"caption-attachment-3141\" class=\"wp-caption-text\">Initiate pivot table execution or pivot<\/figcaption>\r\n<\/figure>\r\n<p>This database contains a large amount of data, but as such does not say much.\u00a0To make the data more useful, we need to aggregate it, group it, get totals, and thus answer some questions:<\/p>\r\n<ul>\r\n<li>What is the amount of the invoice in each branch, divided according to the type of invoice?<\/li>\r\n<li>How many accounts are opened in each branch, by type of account?<\/li>\r\n<li>Which branch opens the most accounts for new customers?<\/li>\r\n<\/ul>\r\n<p>Select any cell in the worksheet, then select\u00a0<strong>Insert \/ Table \/ PivotTable<\/strong>\u00a0.\u00a0The following dialog box will open:<\/p>\r\n<figure id=\"attachment_3159\" class=\"wp-caption alignnone\" aria-describedby=\"caption-attachment-3159\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-3159 size-full\" title=\"Pivoting Dialogue\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/01\/pivot-tabele-03.png\" sizes=\"auto, (max-width: 466px) 100vw, 466px\" 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\" alt=\"Pivoting Dialogue\" width=\"466\" height=\"303\" \/>\r\n<figcaption id=\"caption-attachment-3159\" class=\"wp-caption-text\">Pivoting Dialogue<\/figcaption>\r\n<\/figure>\r\n<figure class=\"wp-block-image alignnone wp-image-166 zoooom\">\r\n<figcaption><\/figcaption>\r\n<\/figure>\r\n<p>In the\u00a0<strong>Table \/ Range<\/strong>\u00a0field, enter the range of cells in the starting table (select the table).\u00a0If we use data from an external file, select the\u00a0<strong>Use an external data source<\/strong>\u00a0option .\u00a0In the lower part of the dialog box, select the place for the derived table: existing or new worksheet.<\/p>\r\n<p>After OK, Excel will create an empty derived table and open the\u00a0<strong>PivoTable Field List<\/strong>\u00a0pane , as shown in the following figure:<\/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\" sizes=\"auto, (max-width: 217px) 100vw, 217px\" 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\" alt=\"\" width=\"217\" height=\"381\" \/><\/p>\r\n<p><strong>Arranging<\/strong>\u00a0derived table elements &#8211; you can use the following procedures:<\/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\" sizes=\"auto, (max-width: 344px) 100vw, 344px\" 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\" alt=\"\" width=\"344\" height=\"625\" \/>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\u00a0<\/p>\r\n<ul>\r\n<li>turn on the switch next to the item at the top of the pane, excel will set this field to one of the four fields at the bottom of the pane<\/li>\r\n<\/ul>\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\" sizes=\"auto, (max-width: 347px) 100vw, 347px\" 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\" alt=\"\" width=\"347\" height=\"502\" \/><\/p>\r\n<ul>\r\n<li>drag the field names (at the top) to the blank derived table on the worksheet<\/li>\r\n<li>drag field names to one of the four fields at the bottom of the Pivot Table Field List pane<\/li>\r\n<li>right-click the field name at the top of the Pivot Table Field List pane and select its location from the context menu.<\/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\" sizes=\"auto, (max-width: 452px) 100vw, 452px\" 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\" alt=\"\" width=\"452\" height=\"652\" \/><\/p>\r\n<p>This procedure creates a table, determines sums (or some other calculations) by columns and rows, automatic formatting, the order in which fields appear.<\/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\" sizes=\"auto, (max-width: 244px) 100vw, 244px\" 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\" alt=\"\" width=\"244\" height=\"308\" \/><\/p>\r\n<h3><span id=\"Najvazniji_pojmovi_izvedenih_Pivot_tabela\" class=\"ez-toc-section\"><\/span><strong>The most important terms of derived (Pivot) tables<\/strong><\/h3>\r\n<ul>\r\n<li><strong>Column label<\/strong>\u00a0&#8211; the\u00a0fields that define the columns are placed in the table header as columns.<\/li>\r\n<li><strong>Row labels<\/strong>\u00a0&#8211;\u00a0fields that define rows in a derived table<\/li>\r\n<li><strong>Grand total<\/strong>\u00a0&#8211;\u00a0a row or column in which the total is displayed<\/li>\r\n<li>Subtotal &#8211;\u00a0<strong>Subtotal<\/strong>\u00a0&#8211; row or column with displayed subtotals<\/li>\r\n<li>Refresh &#8211; updating the\u00a0<strong>totals<\/strong>\u00a0after changing the source data<\/li>\r\n<li>Table\u00a0<strong>filter<\/strong>\u00a0&#8211; a field by which data is extracted<\/li>\r\n<li>Item &#8211;\u00a0<strong>field<\/strong>\u00a0elements &#8211; eg field is Account type, items are savings, current and giro account<\/li>\r\n<\/ul>\r\n<h2><span id=\"Formatiranje_ili_uredenje_izvedene_pivot_tabele\" class=\"ez-toc-section\"><\/span><strong>Format or edit a pivot table<\/strong><\/h2>\r\n<p>Now that the pivot table is done, pay attention to the new toolbar.\u00a0<strong>Two parts, Analysis<\/strong>\u00a0and\u00a0<strong>Design<\/strong>\u00a0, have appeared\u00a0.<\/p>\r\n<figure id=\"attachment_3187\" class=\"wp-caption alignnone\" aria-describedby=\"caption-attachment-3187\"><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\" sizes=\"auto, (max-width: 337px) 100vw, 337px\" 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\" alt=\"Arrange a derived table\" width=\"337\" height=\"170\" \/>\r\n<figcaption id=\"caption-attachment-3187\" class=\"wp-caption-text\">Arrange a derived table<\/figcaption>\r\n<\/figure>\r\n<p><strong>On the Analyze<\/strong>\u00a0bar\u00a0, you can format the data in the table in the\u00a0<strong>Active Fieald section<\/strong>\u00a0, e.g.\u00a0cash amounts in two decimal places, etc.\u00a0or update the billing information in the\u00a0<strong>Data<\/strong>\u00a0section of the\u00a0<strong>Refresh<\/strong>\u00a0button.<\/p>\r\n<p><strong>In the Design<\/strong>\u00a0bar\u00a0, in addition to the style of displaying the table, you can also select the elements to be displayed.<\/p>\r\n<h2><span id=\"Agregiranje_podataka\" class=\"ez-toc-section\"><\/span><strong>Data aggregation<\/strong><\/h2>\r\n<p>We drag those columns whose values \u200b\u200bwe want to aggregate (group) and calculate, count, etc. to the\u00a0<strong>Value<\/strong>\u00a0pane .<\/p>\r\n<figure id=\"attachment_3188\" class=\"wp-caption alignnone\" aria-describedby=\"caption-attachment-3188\"><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\" sizes=\"auto, (max-width: 257px) 100vw, 257px\" 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\" alt=\"Aggregation\" width=\"257\" height=\"381\" \/>\r\n<figcaption id=\"caption-attachment-3188\" class=\"wp-caption-text\">Aggregation<\/figcaption>\r\n<\/figure>\r\n<p>By left-clicking on the column in the submenu, select\u00a0<strong>Value field settings,<\/strong>\u00a0you can select a mathematical function to process the data, e.g.\u00a0add the amount with the\u00a0<strong>SUM<\/strong>\u00a0function , override the amounts with the\u00a0<strong>COUNT<\/strong>\u00a0function , calculate the mean value with the\u00a0<strong>AVERAGE<\/strong>\u00a0function , display the maximum value with the\u00a0<strong>MAX<\/strong>\u00a0function , etc.<\/p>\r\n<h2><span id=\"Izrada_kalkulativnih_kolona\" class=\"ez-toc-section\"><\/span><strong>Making calculation columns<\/strong><\/h2>\r\n<p>In case you need to calculate new values \u200b\u200bin the derived table, and such a column does not exist in the initial table. On the\u00a0<strong>Analyze<\/strong>\u00a0bar , you can format the data in the table in the\u00a0<strong>Active Fieald section<\/strong>\u00a0, e.g.\u00a0cash amounts in two decimal places, etc.\u00a0or to update the calculation data in the\u00a0<strong>Data<\/strong>\u00a0section of the\u00a0<strong>Refresh<\/strong>\u00a0button. An update is in progress.<\/p>\r\n<h2><span id=\"Grupisanje_podataka_-_izrada_stratuma\" class=\"ez-toc-section\"><\/span><strong>Data grouping &#8211; stratum creation<\/strong><\/h2>\r\n<p>If you want to group some rows of the table, right-click on one or as many values \u200b\u200bin the first column as you want to group and select the\u00a0<strong>Group<\/strong>\u00a0option from the submenu .<\/p>\r\n<h2><span id=\"Filtriranje_i_slajsovanje_podataka\" class=\"ez-toc-section\"><\/span><strong>Filter and slice data<\/strong><\/h2>\r\n<p><strong>In the Filters<\/strong>\u00a0pane,\u00a0we can drag the desired column that produces a new row above the pivot table, allowing the user to filter the results in the table.<\/p>\r\n<figure id=\"attachment_3186\" class=\"wp-caption alignnone\" aria-describedby=\"caption-attachment-3186\"><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\" sizes=\"auto, (max-width: 553px) 100vw, 553px\" 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\" alt=\"Filter and slice data\" width=\"553\" height=\"844\" \/>\r\n<figcaption id=\"caption-attachment-3186\" class=\"wp-caption-text\">Filter and slice data<\/figcaption>\r\n<\/figure>\r\n<h2><span id=\"Snimak_postupka_izvodenja_izvestajne_tabele\" class=\"ez-toc-section\"><\/span><strong>A snapshot of the reporting table execution procedure<\/strong><\/h2>\r\n<p>When we run the Excel program, we can access various templates and download instructions on how to work with pivot tables that we gave in the image.\u00a0From the given example you will see a typical case when you can report a table with new aggregate data.\u00a0Let&#8217;s say we have a record (table) of expenses of one family.\u00a0What date, which member bought what and how much he spent.\u00a0<strong><em>\u00a0\u00a0<\/em><\/strong><\/p>\r\n<p><iframe loading=\"lazy\" title=\"derived tables\" src=\"https:\/\/www.youtube.com\/embed\/4m59i4vq2zw?feature=oembed\" width=\"840\" height=\"630\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\" data-mce-fragment=\"1\"><\/iframe><\/p>\r\n<h3><span id=\"Izvori\" class=\"ez-toc-section\"><\/span>Sources<\/h3>\r\n<p><a id=\"f1\" href=\"https:\/\/kalkulacija.com\/wordpress\/izvedene-pivot-tabele\/?preview=true#1\"><sup>1<\/sup><\/a>\u00a0Wikipedia article on the etymological meaning of the word aggregation.\u00a0https:\/\/en.wiktionary.org\/wiki\/aggregatus#Latin<\/p>\r\n<p>&nbsp;<\/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\/en\/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\/en\/power-pivot-tabele\/\">THE REAL POWER OF POWER PIVOT TABLES<\/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 (advanced derived) table includes the process of creating a report table very similar to\u00a0the Pivot table\u00a0, whose main<\/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>\r\n<p><\/p>\r\n<p><\/p>\r\n<p><\/p>\r\n\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;Rate this post&quot;,&quot;legend&quot;:&quot;5\\\/5 - (1 vote)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;THE REAL POWER OF POWER PIVOT TABLES&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>Sorry, this entry is only available in Srpski.<\/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=\"Calculation in essence of everything!\" \/>\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\":\"How to create Pivot Table\",\"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\":[\"Advanced Excel\",\"Pivot table\",\"Excel\"],\"inLanguage\":\"en-US\"},{\"@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\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/izvedene-pivot-tabele\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@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\":\"Calculation in essence of everything!\",\"description\":\"Go ahead! Improve your data processing skills!\",\"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\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@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":"Calculation in essence of everything!","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":"How to create Pivot Table","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":["Advanced Excel","Pivot table","Excel"],"inLanguage":"en-US"},{"@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":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kalkulacija.com\/wordpress\/izvedene-pivot-tabele\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@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":"Calculation in essence of everything!","description":"Go ahead! Improve your data processing skills!","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":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@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\/en\/wp-json\/wp\/v2\/posts\/163","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/comments?post=163"}],"version-history":[{"count":81,"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/posts\/163\/revisions"}],"predecessor-version":[{"id":3690,"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/posts\/163\/revisions\/3690"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/media\/923"}],"wp:attachment":[{"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/media?parent=163"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/categories?post=163"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/tags?post=163"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}