Ranet HTML Pivot Table

Release History

Ranet HTML Pivot Table 5.7.150

July 24, 2017


Pivot Table

  • Sorting option in the pivot table; sorting visualization
  • DrillThrough. Option to export DrillThrough results to Excel
  • Context menu for cells; option to copy cells in the clipboard, view cell properties
  • "Build Filter Axis" command that adds elements to the filter area based on the selected cells' rows and columns
  • "Leave Current Structure" command that filters the pivot table based on selected cells' rows and columns

Pivot Charts

  • Pie charts for pivot table data visualization
  • Option to view series on separate charts, customize chart table
  • Support of the main pivot table actions in the charts
  • Option to show an additional axis on the chart

Member Choice

  • New Member Choice filter applicable to levels
  • Option to view only selected elements
  • Option to view cube member properties
  • Element search

Active Filters

  • Horizontal scrolling in the Active filters area


  • Report export to / import from the user's computer (XML)
  • Report export to URL; opening report via URL


  • Reset button on the Toolbar resets custom calculations and styles

Server Side

  • XML comments to the server code
  • Comments to Angular and JavaScript code
  • Server logic virtual methods for pivot table integration into other applications
  • Server DLL versioning

Design and Usability

  • New design
  • New dialog window for extension customization
  • Botton toolbar for managing multi-page reports
  • Report header and footer customization; header/footer export to Excel


  • Option to modify sizes of all modal windows
  • Selected elements tree normalization. When the cube structure is changed the saved reports are kept operational
  • Wrong filter description in the Active filters area
  • Error executing MDX request when creating custom calculated elements with members from the "Non-empty behavior" editor
  • Error exporting report to Excel when there is no Rows or Columns area in the pivot table
  • Error in the pivot table after "Drilldown with the parent"
  • Error when sorting MDX query execution result in case there are the same elements in Rows or Columns
  • Error generating MDX query when a single member is selected in the Member Choice
  • Error recording history when there are filters applied to the report
  • Error when loading a report with saved user actions
  • TreeView opens closed nodes when adding/deleting elements
  • Error displaying the chart when there are negative values in the data source


6 Rules Of Effective KPI Analysis

Key performance indicators, or KPIs, are important performance measurements that show how effective a company is in achieving its business goals. Well-defined and properly measured KPIs can become key criteria for evaluating and improving the business development...

4 Reasons To Use Web Pivot Tables

Pivot tables are great tools for business data analysis and reporting. They offer easy and comprehensible drag-n-drop interfaces in combination with powerful analytical capabilities. HTML/JavaScript-based web pivot table controls and tools have become very popular,...

Advantages Of Using OLAP for Business Intelligence

High competition for market control forces business owners to find new ways to improve business profitability and growth. Nowadays, a company becomes a winner in this competition if it knows how to manage information effectively. That is why more and more companies...