Advanced Expandable Pivot Table

Get the analysis done with Paldi’s Expandable Pivot table!

The Paldi “Advanced Expandable Pivot Table” is a leading product in the Sisense marketplace. Its maturity and versatility have helped drive positive results for many OEM clients and has been instrumental in their success.

This highly interactive and blazing-fast plugin for expanding and collapsing pivot tables is packed with useful features and enhancements, so you can provide your clients the most complete and compelling experience.

* No Coding Is Required *

Key Highlights:

• Tailored to enhance user engagement with pivot tables. (Inquire about getting access to our tutorial videos to learn all the tricks!)
• Tailored for scaling of design, usage, and seamless migration from Windows to Linux.
• Custom behavior and styling for  PDF Exports and Reports.
• Special module for your own in-cell rendering and table-layout customizations:
  • Present the values any way you want to
  • Add/replace icons according to your values
  • Combine values from multiple columns into the same cell
  • Replace values with text
  • Null and N/A handling
• PIVOT / UNPIVOT / TRANSPOSE Views
• Advanced calculations and capabilities for subtotals
• Customization API for designers!
• Supports our Zero Coding Approach

The Advanced Expandable Pivot Table plugin can be purchased as part of the following PowerUps:

• The “UI Enhancements Power Up” which includes:
  • Advanced Filters
  • Filter Bookmarks
  • Date Range FIlter
  • Input Parameters
  • Export Button
  • Dim Switcher
  • Measure Changer

• The “Pivot & Tables Power Up” which includes:
  • Advanced Table with Aggregation 
  • Pivot Toolbar
  • Pivot2 UI Enhancements
  • Table With Aggregation Enhancements

Pivot Design:

 Trends Analysis:

 Financial Analysis:

 Customized Subtotals:

 Key Features

• Expanding and Collapsing of columns and rows
• Easy drag and drop interface so viewers can restructure the pivot “on the go”
• Allows viewers to build their own custom pivot from a predefined list of measurements and dimensions
• Immediate sorting and filtering, including sorting by multiple columns/rows
• Sorting by hidden fields, (useful when implementing categorial ordering)
• Complete control over the styling of the pivot from the UI in the widget’s edit mode
• Built-in smart Export To Excel functionality
• Built-in JumpToDashboard and drilling functionality from cells AND headers
• Built-in support for HTML and link rendering
• Ability to add checkboxes to the pivot’s dimensions (similarly to this popular plugin)
• Integration with the metadata plugin to support translations within the pivot
• Support for various sparkline charts within the expandable pivot cells
• Fast query results for a better user experience when interacting with the pivot and changing views
• Set measurements in rows, keep them in columns, or create views for financial analysis
• Customizable subtotal calculations by dimension, allowing designers to select which dimensions to include in subtotal calculations

How viewers modify measurements:

 How viewers modify columns and rows: