Grand/Subtotals For Specific Values In Pivot Widget

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. 

 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.

prism.registerControlSubGrandTotal(widget);

 Step 4 – Access the Subtotals / Grand totals from Row's option menu

For more information about Pivot's Subtotals / Grand totals see our documentation.