Transpose a Pivot Table Plugin
Download: Transpose A Pivot Table
Introduction
Out of the box, Sisense does not allow users to structure a pivot table so the metrics are listed vertically on the left side, with the groupings listed across the top. This is commonly used in financial reports.
This plugin will allow users to get this layout.
Implementation
- 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, please create it.
- Open the script editor for the widget you'd like to modify. We have documentation on how to edit a widget's script here:https://www.sisense.com/documentation/extending-dashboard-functiona...
- Put in the following lines of code into your widget script
transposePivot(widget);
4. Click save, and refresh the widget.
Notes
- This widget only supports using one grouping in the rows, and nothing in the columns. You will be alerted if you violate these restrictions.
- I'd suggest using the "Alternating Columns" and "Columns Headers" options in the design section of the widget
Updates
- October 18 2017 - support conditional coloring
- January 16 2019 - support for Sisense 7.2, support for column resizing, bugfixes
-
Hi James,
The Product team is working on a project of re-writing the Pivot component. The transpose capability will be added to the Pivot backlog and will be eventually addressed in the change.I recommend following the Product Updates segment in the community to make sure you get an email notification on future version releases.Thanks,Oxana -
Hi,
It seems that the transpose pivot is causing the download to pdf to fail on Version: 7.1.3.10025. I have the following error when trying to download the PDF: This shouldn't hav happened. Please ask your administrator for assistance. error initializing widget extension - Error: Cant' find variable: transposePivot at createWidgetExtension.
Thanks,
Hugo
-
@Oksana
Microsoft Edge is not supported by Sisense
https://documentation.sisense.com/latest/getting-started/minimum-requirements.htm#gsc.tab=0 -
I suppose it's due to the new version of angular introduced with Sisense 8.1.1:
From the release notes: "Sisense has been upgraded to Angular 1.7.8"
To solve the issue, I just changed the lint 38 of the wrapperService.js file from:
var serviceModel = module.app._invokeQueue
to
var serviceModel = module.ngModule._invokeQueue
Please sign in to leave a comment.
Comments
34 comments