Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I'am looking for change sub total color in a pivot chart. In the attached sample, i'd like to get a red sub total color for country A, orange for country B and green for country C.
I tried with Custom format cell (Ctrl+G) and calculated color but dont't works. Any idea?
Use Background Color in Dimensions and Expressions like this:
=If(Country = 'A' and Len(trim(Shop_ID)) = 0, red(), If(Country = 'B' and Len(trim(Shop_ID)) = 0, yellow(), If(Country = 'C' and Len(trim(Shop_ID)) = 0, blue())))
You will come up with this result:
Adjust the colors to your needs 🙂
Use Background Color in Dimensions and Expressions like this:
=If(Country = 'A' and Len(trim(Shop_ID)) = 0, red(), If(Country = 'B' and Len(trim(Shop_ID)) = 0, yellow(), If(Country = 'C' and Len(trim(Shop_ID)) = 0, blue())))
You will come up with this result:
Adjust the colors to your needs 🙂
Thanks! The
and Len(trim(Shop_ID)) = 0
make the difference 🙂