Showing results for 
Search instead for 
Did you mean: 
Community Team Member
Community Team Member
The following forum post explains how to control Grand totals and Subtotals in the pivot widget.
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).
Pivot shows data without any sub/grand totals.
Pivot shows Subtotal only for 'Total Cost' value.
 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.
  1. Add the following code:
  1. Refresh (F5).
  2. 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.
Version history
Last update:
‎02-13-2024 11:49 AM
Updated by:
Community Toolbox

Recommended quick links to assist you in optimizing your community experience:

Developers Group:

Product Feedback Forum:

Need additional support?:

Submit a Support Request

The Legal Stuff

Have a question about the Sisense Community?

Email [email protected]

Share this page: