Pivot Expression - Get Value from Lookup Table

[#1]

Please help me here.

We Have two tables like below

Table1.

From	To	ColorCode
0	100	RGB(0,255,0)
101	500	RGB(255,251,122)
501	999	RGB(0,255,0)

Table2.

MetricID	DrillDownGroup	value
1	L1	50
2	L1	50
1	L2	45
2	L2	45
1	L3	60
3	L3	60

I have a pivot table with Level(DrillDown Group) in Dimension and Value in Measure.

Background Color of the Measure should be from Table1 based Aggregated Value between From and To.

Level	Value
L1	100
L2	90
L3	120

Note: The Color should change in runtime because the Aggregated value will change drill down to next level.

[settu_periasamy]

Hi,

If there is no relation between your table , you can't directly give your range in the chart..

May be you can use the if condition in background expression.. Like

if(Value >0 and Value <=100, RGB(0,255,0))

Like wise other conditions..

Or in the backend , you can Aggregate your second Table,check your range using if condition, and create new color code field based on your range..