cancel
Showing results for 
Search instead for 
Did you mean: 
intapiuser
Community Team Member
Community Team Member

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
Rate this article:
Version history
Last update:
‎03-02-2023 09:19 AM
Updated by:
Contributors