Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Several question pivot table config.

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

0 Replies