How do you format Web Reporting pivot table data?

Question

By default, setting up a pivot table via the web reporting package seems to display data in some float format. Is it possible to truncate decimals, or insert commas where appropriate for large numbers? Or how can we format a decimal into a percentage?

Answer 1

For formatting cells you've two different options :

1) You can use MDX (this includes float formatting & colors). See FORMAT_STRING and Cell Properties for all options ( CLASSNAME example is worth checking ).

2) You can also define in the reporting : Widget / Columns / Cell Renderer / Format ...

Hope it helps