Pivot Table design

[saharadi]

hey, 

can i create this pivot table design? 
i want a that the first dimension all row background color will be gray but when i drill down to worker (open the "+") the background will be white

[pravinboniface]

@saharadi You can use a background color expression on the measure to set the color by dimensionality() as follows:

if(Dimensionality()=1,Red(), blue())

[saharadi]

thank you 🙂 
do you know if i can control the text and backgrond color of NULL values here?