4 Replies Latest reply on May 19, 2018 3:50 PM by Okechukwu Ossai

    multiple number formats for pivoted data values?

    Scott Laronge

      I'm visualizing data that's being read from a pivot table, or otherwise structured form of a data table in google sheets.

       

      I've followed the instructions to treat the data as pivoted when I import it on the data source. 

       

      One issue I'm having is that I have a variety of data types: integer, decimal, percent, and revenue that I'd like to format differently.  Except if I try to format the "Pivot Field Values" it'll apply this to each data field.  Is there a way (other than to do some sort of if([Pivot Field Name]='revenue' then [Pivot Field Value] end) statement to separate out each and every one?  Perhaps apply the Number Format to the values on the sheet only and not globally?