Grand/Subtotals For Specific Values In Pivot Widget
Download: Control Sub Grand Total
Introduction
The following forum post explains how to control Grand totals and Subtotals in the pivot widget.
Purpose
When we want to display Grand/Subtotal it's not always relevant for ALL values/columns, but only to some. We'd like to control which values/columns will show Grand/Subtotal.
The plugin supports pivots only and enables show/hide specific values from Grand/Subtotal, only for rows (and not columns).
Example
Before:
Pivot shows data without any sub/grand totals.

After:
Pivot shows Subtotal only for 'Total Cost' value.

Steps
Step 1 - Download and extract the enclosed zip file into the plugins folder:
C:\Program Files\Sisense\PrismWeb\plugins\ControlSubGrandTotalFromMenu, if the "plugins" folder is not there, please create it. If you are using version 7.2 and higher unzip the contents into your C:\Program Files\Sisense\app\plugins\ folder.
Step 2 - Create a pivot table widget
Create your desired pivot table, add rows, values and columns as needed. Choose 'Apply'.
Step 3 – Script Options
Edit the widget, and edit the widget script.
- Add the following code:
prism.registerControlSubGrandTotal(widget);
- Refresh (F5).
- Choose 'Apply'.
Step 4 – Access the Subtotals / Grand totals from Row's option menu

See also
For more information about Pivot's Subtotals / Grand totals see our documentation.
Updated 02-13-2024
intapiuser
Admin
Joined December 15, 2022