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

    Format tabla pivot

    Pablo Lira

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

      tablapivot2.JPG.jpg

      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.

       

      \m/

      P.L.