0 Replies Latest reply: Nov 20, 2013 10:12 AM by Pablo Lira RSS

    Format tabla pivot

      Hi fellows, this a simple example of how I want to display the data:


      the expression is set to INTEGER with format #.##0.


      I want to "Dimension2" with value "US$" the expression is displayed with 2 decimal places('##0,00'), value "Year" without format and

      the rest with format numeric without decimals.


      Try on EXPRESSIONS / TEXT FORMAT / DEFINITION ---> = if (Dimension2 = 'US$', Num# (expression, '# # 0,00 "))

      but does not work because I think there just takes bold, italic, etc, etc and not the formats numeric.


      thanks any help, and sorry my english.