Pivot2: "Add Financial Formatting To Pivots" Re-Implemented
Introduction
This article explains how to adjust Pivot tables to use standard financial formatting of numbers. This means showing negative numbers as always RED with parentheses instead of a minus sign, as well as populating empty (null) cells with 0 values.
Before

After

Steps
The following steps will walk through the process of adding the new plugin.
STEP 1 - ADD THE PLUGIN
Download the latest version of the plugin from this link and extract the enclosed folder into the plugins folder:
/opt/sisense/storage/plugins/
STEP 2 - CREATE THE PIVOT
On your dashboard, edit or create a new pivot table and click on the settings menu at the top right of the screen. You should see some new options under Financial Formatting.

References/Notes
- This plugin was developed for just pivot tables
- The negative formatting is set to only be applied to percentages and currency values, regular numbers will be ignored by this plugin
Updated 03-02-2023
intapiuser
Admin
Joined December 15, 2022