🍉 Meet Flexmonster Pivot Table & Charts 2.9.Check out all hot features!
Get Free Trial

how do i display negative numbers like in excel

niraj asked on April 13, 2018

for example I might want a negative number with parenthesis (212,33.12)
or I might want it with a negative sign -212,313.12
or I might want it in red etc 
i’m interested in the common excel variations

1 answer

Dmytro Zvazhii Dmytro Zvazhii Flexmonster April 16, 2018

Hello Niraj,
Thank you for your question. We recommend trying our customizeCell feature – https://www.flexmonster.com/api/customizecell/. It is a really powerful tool for changing pivot’s view. Here is an example of how it can be used – http://jsfiddle.net/flexmonster/cc2kyzfe/.
Please let us know if it works for you.

Please login or Register to Submit Answer