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
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.
Regards,
Dmytro