6 Replies Latest reply on Jul 23, 2018 3:08 AM by Artee Jajoo

    Multiple Number Formats in Same Column

    Ramin Melikov

      Hi,

       

      I have data that looks like this

       

      Dimension; Dimension1; Measure1; Dimension2; Measure 2

      Object A; 5.01; 5.01; 6.5; 6.5

      Object B; 3%; 0.03; 4%; 0.04

      Object C; 0.4; 0.4; 1.2; 1.2

      Object D; 2%; 0.02; 20%; 0.2

       

      So, if I am dropping the Measure Values pill, it shows me all the numbers in decimal format. But, I want some of them to be percentages like it says in my dimensions.

       

      How do I do this in the same sheet using only measures?