* * This post is a re-implementation of the old pivot1 plugin that can be found in this link * *
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.
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:
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.
- 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
Please sign in to leave a comment.