This will take the empty gender values in pivot tables and replace them with 'N/A'
- Navigate to
X:\Program Files\Sisense\PrismWeb\plugins\
- Create a new folder named
pivotFix
and paste the files in this directory into the new folder. - In your SiSense dashboard, navigate to the particular widget you'd like to run the code on
- Inside the widget view, click on the hamburger menu, then click Edit Script.
- Copy and paste the following code
widget.on('initialized', function() {
pivotFix(widget);
});