{"id":7683,"date":"2024-12-03T13:41:12","date_gmt":"2024-12-03T11:41:12","guid":{"rendered":"https:\/\/bitimpulse.com\/?post_type=manual&#038;p=7683"},"modified":"2024-12-03T13:42:20","modified_gmt":"2024-12-03T11:42:20","slug":"zvedena-tablyczya","status":"publish","type":"manual","link":"https:\/\/bitimpulse.com\/en\/manual\/zvit-interaktyvnyj-deshbord\/zvedena-tablyczya\/","title":{"rendered":"Pivot"},"content":{"rendered":"<p>Pivot is a multidimensional array of data.<\/p>\n<p>Let us take a \u201cPivot\u201d that shows volume of sales and profit by product category in each country as an example. For this we choose \u201cPivot\u201d in the toolbar, in the value field we will have \u201cReseller Sales Amount\u201d and \u201cReseller Gross Profit\u201d measures, on the rows of the \u201cCountry\u201d and \u201cCategory\u201d hierarchy. The pivot will look the following:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_5_1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7684\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_5_1.png\" alt=\"\" width=\"1001\" height=\"699\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_5_1.png 1001w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_5_1-450x314.png 450w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_5_1-300x209.png 300w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/12\/8_5_1-768x536.png 768w\" sizes=\"auto, (max-width: 1001px) 100vw, 1001px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>","protected":false},"featured_media":0,"parent":4864,"menu_order":189,"template":"","manuals":[17],"class_list":["post-7683","manual","type-manual","status-publish","hentry","manuals-bat-report"],"_links":{"self":[{"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/manual\/7683","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/manual"}],"about":[{"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/types\/manual"}],"up":[{"embeddable":true,"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/manual\/4864"}],"wp:attachment":[{"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/media?parent=7683"}],"wp:term":[{"taxonomy":"manuals","embeddable":true,"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/manuals?post=7683"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}