1 2 Previous Next 16 Replies Latest reply on Mar 31, 2015 11:37 AM by Cathy Barclay

    Change Number Format for Measure Based on Measure Description

    Aaron Mackey

      Good afternoon,

       

      Please see the attached workbook. 

       

      Is there a way to change the number format depending on the Measure description when working with unpivoted data?  For example, I want "Value A" numbers to have no decimal places, while "Value B" and "Value C" have two decimal places. 

       

      Raw Data

      Item IDMeasureValue
      1Value A1.99
      1Value C7.99
      2Value A3.99
      2Value B4.99
      2Value C6.99
      etc...etc...etc...

       

      Dashboard Table

      Item IDValue AValue BValue C
      11.997.99
      23.994.996.99
      32.993.504.50

       

      Thank you,

      Aaron

        1 2 Previous Next