I have a pivot table, I would like to specify the color of the group

[#1]

I have a pivot table, I would like to specify the color of the group

A, C group, the Red. (Dimension and expression both)
B, D group, the Green. (Dimension and expression both)

grp | grp2 | 1 | 2 | 3 | 4 | total
A | a
b
c
d
B | a
b
c
d
C | a
b
c
d
D | a
b
c
d
total | a
b
c
d

Help please....

[#2]

Hi nannaya,

you can try use if function in background color of Group dimension and expression.

In your case you can try

if(grp='A' or grp='C',red(),rgb(0,250,0))

hope this help,

Regards.

[#3]

Thank you. tatarjar.

However, the above sample, exactly matching the group're assigning the lines looks like the color.

I want this fixed unfolding is not a group of

In other words, the first group of odd red. The second group would represent an even blue.

[#4]

Sorry I don't know how to fix your problem.

But if you no need to fix the color, you can try change the style of object to Pyjama type. This style look like what you looking for.

[#5]

One solution would be to create a table that specifies a color for each group name and then set the background color of both the dimensions and expressions to this color. Attached is an example of this.