Pivot Expression - Get Value from Lookup Table

Tue, 09 Feb 2016 22:19:32 GMT

Please help me here.

We Have two tables like below

Table1.

Table2.

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.

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

Re: Pivot Expression - Get Value from Lookup Table

settu_periasamy — Wed, 10 Feb 2016 02:10:26 GMT

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..