{"id":102672,"date":"2014-11-26T11:06:34","date_gmt":"2014-11-26T09:06:34","guid":{"rendered":"http:\/\/guriddo.net\/?page_id=102672"},"modified":"2014-12-07T16:06:26","modified_gmt":"2014-12-07T14:06:26","slug":"guriddo-pivotgrid-js","status":"publish","type":"page","link":"http:\/\/guriddo.net\/?page_id=102672","title":{"rendered":"Guriddo PivotGrid JS"},"content":{"rendered":"
\n

What is Guriddo PivotGrid JS?<\/h2>\n

\nGuriddo PivotGrid JS is a component that you can use with Guriddo jqGrid to create a pivot grid. PivotGrid JS inherits the Guriddo jqGrid, so you can use most of the features you are already familiar with: column resizing, formatter, cell renderers, row\/cell events etc. The PivotGrid JS can be used when you want to get summation and pivot features that aren\u2019t provided in the Guriddo jqGrid. This component is included as a part of Guriddo jqGrid JS and is a bonus to the package.\n<\/p>\n\n\n\n
\n<\/td>\n\nDownload<\/a><\/td>\nLicense\/Pricing<\/a><\/td>\n\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

FEATURES<\/h3>\n

\n
\n\"Multibrowser\"<\/a><\/p>\n

MULTIPLATFORM<\/h4>\n


\nBrowser support is an important part of our grid. Guriddo PivotGrid support all modern mobile and desktop browsers including the iPhone\/iPad and Internet Explorer from version 8. Browser support reference is tested regularly with all major browsers. <\/p>\n

\n
\n\"Free\"<\/a><\/p>\n

FREE FOR NON-COMMERCIAL<\/h4>\n


\nIf you want to use Guriddo PivotGrid JS for a personal website or a non-profit organisation, you don’t need the author’s permission, just go on and use Guriddo PivotGrid JS. For commercial websites and projects, see License and Pricing.\n<\/p>\n

\n
\n\"Open\"<\/a>
\nOPEN<\/h4>\n


\nIndependent of the license of Guriddo PivotGrid JS, free or not, you are allowed to download the source code and make your own edits. This allows for personal modifications and a great flexibility.\n<\/p>\n

\n\"pivotsimple\"<\/a>
\nBASICS<\/h4>\n

\nBasic pivot require minimal settings. To break down the dataset into simple summary, you just have to configure the xDimention object.\n<\/p>\n

\n\"pivotagragates\"<\/a>
\nMULTIPLE LEVELS<\/h4>\n


\nMultiple levels are supported, so you can just specify them in the y and x Dimensions. Grouping the rows and\/or columns is done automatically when two or more levels are set in xDimension and\/or yDimension. Now that you broke down the dataset on the y and x Dimension, it\u2019s time to aggregate the cell values. Several kinds of aggregations are available including: sum, min, max, count etc. Future release will provide your own aggregation function.\n<\/p>\n

MORE FEATURES<\/h4>\n
\n
    \n
  • Automatically grouping of data when xDimension has more than one item <\/li>\n
  • We support summary at for the group if a summaryType is set in agregates items <\/li>\n
  • Frozen columns for easy reading the report<\/li>\n
  • We can have unlimited summary rows. In this case we need to set the aggregates array. <\/li>\n
  • Searching a already constructed pivot<\/li>\n<\/ul>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

    What is Guriddo PivotGrid JS? Guriddo PivotGrid JS is a component that you can use with Guriddo jqGrid to create a pivot grid. PivotGrid JS inherits the Guriddo jqGrid, so you can use most of the features you are already […]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":102666,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"blank.php","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0},"_links":{"self":[{"href":"http:\/\/guriddo.net\/index.php?rest_route=\/wp\/v2\/pages\/102672"}],"collection":[{"href":"http:\/\/guriddo.net\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"http:\/\/guriddo.net\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"http:\/\/guriddo.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/guriddo.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=102672"}],"version-history":[{"count":25,"href":"http:\/\/guriddo.net\/index.php?rest_route=\/wp\/v2\/pages\/102672\/revisions"}],"predecessor-version":[{"id":103530,"href":"http:\/\/guriddo.net\/index.php?rest_route=\/wp\/v2\/pages\/102672\/revisions\/103530"}],"up":[{"embeddable":true,"href":"http:\/\/guriddo.net\/index.php?rest_route=\/wp\/v2\/pages\/102666"}],"wp:attachment":[{"href":"http:\/\/guriddo.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=102672"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}