2 Replies Latest reply: May 22, 2012 10:06 AM by Mikael Cleuziou RSS

    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