Dear all,

Could you please help me with the following:

I have two charts:
I have a pie chart showing revenue by country.
I have a horizontal stacked bar chart, showing service lines on Y-axis and within each service line, the revenue stacked per country on X-axis.

I face two challenges:
My horizontal stacked bar chart in sorted on the Y-axis, showing service lines from most revenue (up) to lowest (down). However, i don't know how to sort the stacked pieces that make up each service line.

Additionally, I want to align the color palette of the pie chart by country to the color palette of the stacked parts.

I use pentaho CDE 6.0.