Download: Pivot Checkboxes
This article explains how to add filter checkboxes to a pivot table.
When showing a pivot table, you can make multiple selections by holding control and right clicking on several cells to set a filter. This plugin provides a way to add checkboxes to cells, which gives the user a quick way to make multiple selections.
The following steps will walk through the process of adding the plugin and creating a sample pivot table.
Step 1 - Add the Plugin
Download the attachment and unzip the contents into your C:\Program Files\Sisense\PrismWeb\plugins\ folder. If you are using version 7.2 and higher unzip the contents into your C:\Program Files\Sisense\app\plugins\ folder. If the plugins folder doesn't exist, just create it. After those files have been unzipped there, you may also have to restart the web server. Now, when you create a new pivot table widget the checkbox option should show up in the context menu of the ROWS dimensions.
Step 2 - Create the Pivot Table
On your dashboard, click the Create Widget button and select Advanced Configuration. Next, select the Pivot Table Chart from the chart types menu. Pick one or more dimensions under the ROWs category and click on the settings icon to configure the checkboxes.
Make sure the pivot table is set to have Widget Affects Dashboard Filters and Enable Drill To Anywhere are DISABLED. Also make sure the dashboard filters are set to HIGHLIGHT. The widget settings should match the image below.
- This plugin does not support drilldown and is only enabled for ROW dimensions in pivot tables
- UPDATED May 5, 2016 - Fixed a bug when using this plugin with filters set for "All Items"
- UPDATED July 5, 2016 - Modified to work with code changes in v6.4 and dependent filters
- UPDATED Aug 5, 2016 - Fixed a bug when making multiple selections
Please sign in to leave a comment.