Background Color in Pivot chart While expanding

[CharanY28]

Hi All,

I have Pivot chart as Below

1)

2)

I want to see the blue color for Total by Universities only when it's expanded , currently it's showing when even when It's not expanded also like in 1st picture, I want to Uncheck Full expanded and Collapse option and want to see Blue color for total only when expanded like in 2nd picture without expanding initially

How to do??

Please help thanks

[JandreKillianRIC · Accepted solution]

Hi @CharanY28 

Just use Dimensionality() 

Something like 

=IF(Dimensionality() > 1, Blue(), White()) (just use this with your current color expression) 

Regards Jandre