Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try
only({1}RGB(REGIONR,REGIONG,REGIONB))
as background color attribute expression. Set expression only works with aggregation functions like sum(), only() ...
Try
only({1}RGB(REGIONR,REGIONG,REGIONB))
as background color attribute expression. Set expression only works with aggregation functions like sum(), only() ...
Many thanks, 15 526=> It was me.