0 Replies Latest reply: Apr 4, 2016 8:02 PM by Josh Chang RSS

    Several question pivot table config.

    Josh Chang

      Hello,

       

      I'm building a pivot table.

      Few questions need help.

      Here is the preliminary result of this pivot table.

      PivotTable.PNG

       

      1. Is it a way to use a variable to control what madelName I would like to show in this table

          for example I just want to show records which modelName = 'CZH*' or modelName='SO*'?

       

      2. I would like to use background in Chart Properties > Expressions > one of expression > Background to give the same color to the same quarter, and mean while the color will change if the value of the Yield or KDPM is great than a threshold. It seems the Visual Cues can't override the background setting

       

      3. How to change the font type and size of the header row?

       

       

      Thanks,

      Josh