6 Replies Latest reply on Feb 11, 2016 1:55 PM by Brook Bisrat

    Format Percent in Pivot Values on a Tex table

    Brook Bisrat

      Hi All,

       

      I uploaded a csv into Tableau, pivoted the data and realized that some of the values where whole numbers and some where decimals. So for example I had a value of 1000 in price column and a value of 0.25 in the tax column. I want the value of 0.25 to show as 25%. Is there way to do some type of calculated field on the pivot field values or pivot field names to do this. Something like If this pivot field name is this then make its value in percent? Or a custom number format? Or where I make 0.25, 25 in my data and then do some type of formula so that tax values have the text "%" next to them.

       

      What is the best solution?

       

      Thanks!

      Brook