RGB and SET ANALYSIS

[mikael_cleuziou]

Hello,

I have a problem with a set analysis in a RGB function.

I have joined an example.

1) I have amounts by City, Region, Country

2) I have an apple pie with a drill functionnality

3) I have a chart with a set analysis on ALL Region from France

4) I have a RGB function to define Regions colors.

My problem : When I choose in my apple pie one region in France, I keep all my regions bars but I loose two colors.

My solution (doesn't works...) : RGB({1}REGIONR,REGIONG,REGIONB) or RGB({1}REGIONR,{1}REGIONG,{1}REGIONB)

I don't know how to do a set analysis with a RGB!

Thanks for your help...

Mika

[swuehl · Accepted solution]

Try

only({1}RGB(REGIONR,REGIONG,REGIONB))

as background color attribute expression. Set expression only works with aggregation functions like sum(), only() ...

[mikael_cleuziou]

Many thanks, 15 526=> It was me.