Hello,
I'm building a pivot table.
Few questions need help.
Here is the preliminary result of this pivot table.
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