Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi @CharanY28
Just use Dimensionality()
Something like
=IF(Dimensionality() > 1, Blue(), White()) (just use this with your current color expression)
Regards Jandre
Mark the solution as accepted that solved your problem and if you found it useful, press the like button! Check out my YouTube Channel | Follow me on LinkedIn
Hi @CharanY28
Just use Dimensionality()
Something like
=IF(Dimensionality() > 1, Blue(), White()) (just use this with your current color expression)
Regards Jandre
Mark the solution as accepted that solved your problem and if you found it useful, press the like button! Check out my YouTube Channel | Follow me on LinkedIn