*This plugin is officially supported by Sisense. You can find the latest version of this plugin on the Sisense Add-Ons page.
The following article describes the steps needed to implement the “table widget with aggregation” plugin
In some cases there is a need to sort a pivot table rows based on lowest granularity, however, since the pivot table groups the data, one can only sort the rows inside every group and not in the entire pivot. Aggregating the data in a table widget allows this kind of sorting.
Sorting the most revenued categories by country can be done by 2 options:
Pivot table - allows to sort the brands in each category
Aggregated Table - enables to see the most revenued categories including the brands breakdown
Step 1 - Download and extract the enclosed folder into the plugins folder:
C:\Program Files\Sisense\PrismWeb\plugins\tableWidget, if the "plugins" folder is not there, please create it
Step 2 - Create a new widget
Step 3 - Click the drop down widget selector menu, and pick the TABLE WITH AGGREGATION. (Highlighted in the picture)
Step 4 - All new fields added to the table can now be aggregated
* The plugin was updated to work on version 6
*****UPDATE Aug 30th, 2017: Export to PDF is now working on version 6.6.1 and above.
Please sign in to leave a comment.