{"id":4153,"date":"2017-08-10T15:00:12","date_gmt":"2017-08-10T11:00:12","guid":{"rendered":"https:\/\/dhtmlx.com\/blog\/?p=4153"},"modified":"2025-03-11T13:30:19","modified_gmt":"2025-03-11T10:30:19","slug":"meet-new-component-dhx-pivot-build-powerful-pivot-tables","status":"publish","type":"post","link":"https:\/\/dhtmlx.com\/blog\/meet-new-component-dhx-pivot-build-powerful-pivot-tables\/","title":{"rendered":"Meet New Component &#8211; dhtmlxPivot 1.0 To Build Powerful Pivot Tables"},"content":{"rendered":"<p>We are excited to announce the first release of dhtmlxPivot &#8211; <a href=\"\/\/dhtmlx.com\/docs\/products\/dhtmlxPivot\/\" target=\"_blank\">JavaScript pivot table<\/a>. What is a pivot table? It is a table with advanced functionality that allows you to store the summary of a particular data set. It&#8217;s pretty useful in the case of seemingly endless numbers of records to be processed.<\/p>\n<div class=\"center top-20\">\n    <a href=\"\/\/dhtmlx.com\/docs\/products\/dhtmlxPivot\/download.shtml\" target=\"blank\" title=\"\" class=\"btn-thin-green\" onclick=\"ga('send', 'event', 'button', 'click', 'download-pivot-blog')\">Download Pivot<\/a>\n<\/div>\n<p><\/br><br \/>\nThe version 1.0 introduces basic functionality and will mostly cover the needs of your business app. <strong>So, here are the main advantages of dhtmlxPivot 1.0:<\/strong><\/p>\n<ul>\n<li>A drag-and-drop oriented interface that allows using it with ease. You can simply summarize or rearrange the existing columns by dragging.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/dhtmlx.com\/blog\/wp-content\/uploads\/2017\/08\/pivot-gif.gif\" alt=\"what does a pivot table do\" width=\"880\" height=\"597\" class=\"aligncenter size-full wp-image-4176\" \/><\/p>\n<ul>\n<li>Taking into account that pivot tables allow extracting the required data out of thousand of rows, incredibly fast rendering of dhtmlxPivot will be one of the main advantages.<\/li>\n<li>The Pivot component is fully configurable and customizable via its extensive API.<\/li>\n<li>You can embed DHX Pivot in your cross-browser app as the component works and renders equally well in all web browsers.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/dhtmlx.com\/blog\/wp-content\/uploads\/2017\/08\/Browsers-tiny.png\" alt=\"what is pivot table for\" width=\"800\" height=\"150\" class=\"aligncenter size-full wp-image-4160\" srcset=\"https:\/\/dhtmlx.com\/blog\/wp-content\/uploads\/2017\/08\/Browsers-tiny.png 800w, https:\/\/dhtmlx.com\/blog\/wp-content\/uploads\/2017\/08\/Browsers-tiny-300x56.png 300w, https:\/\/dhtmlx.com\/blog\/wp-content\/uploads\/2017\/08\/Browsers-tiny-768x144.png 768w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><\/p>\n<ul>\n<li>There are <a href=\"https:\/\/docs.dhtmlx.com\/pivot\/1-5\/how_to_start.html\" target=\"_blank\">few simple steps to start working with Pivot<\/a> and integrate in your app.<\/li>\n<li>Localize the elements of the component and display them in the language you need.<\/li>\n<\/ul>\n<div class=\"center top-20\">\n    <a href=\"\/\/dhtmlx.com\/docs\/products\/dhtmlxPivot\/download.shtml\" target=\"blank\" title=\"\" class=\"btn-thin-green\" onclick=\"ga('send', 'event', 'button', 'click', 'download-pivot-blog')\">Download Pivot<\/a>\n<\/div>\n<p><strong>What is the purpose of a pivot table?<\/strong><\/p>\n<p>Like any other table based app, a pivot table consists of rows and columns. Additionally, it contains user-specified data fields and pages. All these components can be moved through the table grid in order to help a user to group the particular data in real time. When a user specifies the value of a data-field, a pivot table can convert the header of each column into a data option which can be manipulated by a user. There\u2019s also a possibility to display different summaries of data such as frequencies and averages.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/dhtmlx.com\/blog\/wp-content\/uploads\/2017\/08\/pivot-table-dhx.png\" alt=\"what does a pivot table do\" width=\"900\" height=\"515\" class=\"aligncenter size-full wp-image-4174\" srcset=\"https:\/\/dhtmlx.com\/blog\/wp-content\/uploads\/2017\/08\/pivot-table-dhx.png 900w, https:\/\/dhtmlx.com\/blog\/wp-content\/uploads\/2017\/08\/pivot-table-dhx-300x172.png 300w, https:\/\/dhtmlx.com\/blog\/wp-content\/uploads\/2017\/08\/pivot-table-dhx-768x439.png 768w\" sizes=\"auto, (max-width: 900px) 100vw, 900px\" \/><\/p>\n<p><strong>Related links:<\/strong><\/p>\n<ul>\n<li><a href=\"\/\/dhtmlx.com\/docs\/products\/dhtmlxPivot\/\" target=\"_blank\">Visit Pivot page with a live demo<\/a><\/li>\n<li><a href=\"https:\/\/docs.dhtmlx.com\/pivot\/1-5\/how_to_start.html\" target=\"_blank\">How to start working with dhtmlxPivot<\/a><\/li>\n<li><a href=\"https:\/\/snippet.dhtmlx.com\/3xqkml4u?tag=pivot\" target=\"_blank\">View samples<\/a><\/li>\n<\/ul>\n<p>Note: dhtmlxPivot is a standalone component and isn&#8217;t included in dhtmlxSuite library. <\/p>\n<p><strong>dhtmlxPivot can provide you with a more efficient way of reports creation.<\/strong> Freeing you from hours of routine work, it allows extracting the portions of data according to a particular criterion. Such feature allows automating dozens of repetitive operations with data. You can analyze the data consisting of thousands of records with ease and arrive at quick decisions.<\/p>\n<p>The component will be constantly improved and receive <a href=\"\/\/dhtmlx.com\/docs\/products\/dhtmlxPivot\/\" target=\"_blank\">new features<\/a> soon. We&#8217;ll be glad to receive feedback from the first users of our new component. And you are always welcome to send your feature requests and other suggestions.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>We are excited to announce the first release of dhtmlxPivot &#8211; JavaScript pivot table. What is a pivot table? It is a table with advanced functionality that allows you &#8230;<\/p>\n","protected":false},"author":2,"featured_media":4155,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17,70,1,38],"tags":[33,57,4],"class_list":["post-4153","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-posts-for-codeproject-com","category-releases","category-uncategorized","category-visible","tag-all-posts","tag-pivot","tag-dhtmlx-updates"],"_links":{"self":[{"href":"https:\/\/dhtmlx.com\/blog\/wp-json\/wp\/v2\/posts\/4153","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dhtmlx.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dhtmlx.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dhtmlx.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/dhtmlx.com\/blog\/wp-json\/wp\/v2\/comments?post=4153"}],"version-history":[{"count":5,"href":"https:\/\/dhtmlx.com\/blog\/wp-json\/wp\/v2\/posts\/4153\/revisions"}],"predecessor-version":[{"id":13559,"href":"https:\/\/dhtmlx.com\/blog\/wp-json\/wp\/v2\/posts\/4153\/revisions\/13559"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dhtmlx.com\/blog\/wp-json\/wp\/v2\/media\/4155"}],"wp:attachment":[{"href":"https:\/\/dhtmlx.com\/blog\/wp-json\/wp\/v2\/media?parent=4153"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dhtmlx.com\/blog\/wp-json\/wp\/v2\/categories?post=4153"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dhtmlx.com\/blog\/wp-json\/wp\/v2\/tags?post=4153"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}