Sub total line color in pivot chart

[sergio0592]

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?

[MindaugasBacius · Accepted solution]

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 🙂

[sergio0592]

Thanks! The

and Len(trim(Shop_ID)) = 0

make the difference 🙂