Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am unable to change the background color of final Total value which is in Pivot table. I tried using the custom format cell as well but I am unable to achieve it. Any idea how can I achieve this?
I have achieved this using the below..
=If(Dimensionality() = 0, RGB(192,192,192))
I have achieved this using the below..
=If(Dimensionality() = 0, RGB(192,192,192))