This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Cookie Policy. Click Preferences to customize your cookie settings.
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
