Knowledge Base Article

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
No CommentsBe the first to comment