Custimize slice pie

[lucas]

Hello,
I used the Designer of Style for color slices pie.

Now I would like to associate the color slices with the colors that I decided on my db.
I explain with an example.
I have on my DB this association from category and color:

England -> Red
Russia -> Blue
USA -> Green
France -> Yellow
Italy -> White

And my style on the report contains the previos color in the same order: red, blue, green, yellow, white.

Now I pass to my report this dataset to draw the pie:

England = 25
USA = 55
Italy = 20

And the color of the slices pie are represent like:

England -> Red
USA -> Blue
Italy -> Green

But I would like this representation was:

England -> Red
USA -> Green
Italy -> White

Ultimately I would like maintain the same color I have decided on my DB.

Is it possible?

I remain available for further clarification, thanks in advanced,
Luca

[HighAley]

Hello, Luca.

I used the Designer of Style for color slices pie.

Now I would like to associate the color slices with the colors that I decided on my db.
I explain with an example.
I have on my DB this association from category and color:

England -> Red
Russia -> Blue
USA -> Green
France -> Yellow
Italy -> White

And my style on the report contains the previos color in the same order: red, blue, green, yellow, white.

Now I pass to my report this dataset to draw the pie:

England = 25
USA = 55
Italy = 20

And the color of the slices pie are represent like:

England -> Red
USA -> Blue
Italy -> Green

But I would like this representation was:

England -> Red
USA -> Green
Italy -> White

Ultimately I would like maintain the same color I have decided on my DB.

Is it possible?

You can do it using Condition. Please, see the attached report template.

Thank you.