Set background color stacked pie chart with trellis

[eddysanchez]

Hi all

I have a pie chart with trellis and 3 dimensions, I don't know why the sequence of colors is different for any dimension (see the legend)

I want to set the colors in order of dimension values

Example:

Planned 0 --> Blue color

Planned 1 --> Red color

Planned 1 --> Green color

Planned 1 --> Yellow color

Actual 0 --> Blue color

Actual 1 --> Red color

Actual 1 --> Green color

Actual 1 --> Yellow color

My qvw app attached and the expected result

Thank you very much

[eddysanchez · Accepted solution]

I solved in the script including first the dimension values in order and after that deleting this rows

Table:

LOAD *

Inline [

Target Matrix,Planned,Actual,Value

,0,0

,1,1

,2,2

,3,3

A3,3,0,9

A1,0,1,23

A1,1,1,14

A2,2,1,17

A1,0,2,34

A1,0,3,30

];

Temp:

NoConcatenate

LOAD *

Resident Table

Where [Target Matrix] <> '';

DROP Table Table;

RENAME Table Temp to Table;