Background Color in Pivot chart While expanding

CharanY28 — Tue, 25 Mar 2025 06:48:33 GMT

Hi All,

I have Pivot chart as Below

1)

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

Re: Background Color in Pivot chart While expanding

JandreKillianRIC — Tue, 25 Mar 2025 09:23:47 GMT

Hi @CharanY28

Just use Dimensionality()

Something like

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

Regards Jandre

topic Re: Background Color in Pivot chart While expanding in App Development

Background Color in Pivot chart While expanding

Re: Background Color in Pivot chart While expanding