Filtering Based on Expression Results

[limfungkeat]

Customer Name	Focus Product (RM )	All Products ( RM )	Class	Contribution
Total	1,007,350.82	1,136,457.53	A	88.64%
AAA	50,680.50	54,960.50	A	92.21%
BBB	23,925.50	24,920.90	A	96.01%
CCC	22,134.20	22,134.20	A	100.00%
DDD	21,000.00	21,000.00	A	100.00%
EEE	18,451.48	18,835.48	A	97.96%
FFF	17,529.04	23,287.96	A	75.27%
GGG	15,661.60	19,552.60	A	80.10%
HHH	15,659.82	18,312.78	A	85.51%
LLL	13,032.68	13,032.68	A	100.00%
MMM	12,733.80	22,601.85	A	56.34%
NNN	11,169.60	11,169.60	B	100.00%
OOO	10,750.00	10,750.00	B	100.00%
PPP	10,500.00	11,914.40	B	88.13%
QQQ	10,457.74	11,457.74	B	91.27%
RRR	10,436.80	11,084.80	B	94.15%
SSS	10,286.00	11,647.40	B	88.31%
TTT	9,012.00	9,012.00	B	100.00%
YYY	8,990.39	10,312.97	B	87.18%
UUU	8,814.90	9,732.90	B	90.57%
VVV	8,756.00	9,507.08	B	92.10%
ADASD	8,607.80	9,231.80	B	93.24%
ASDSA	8,076.20	9,250.40	B	87.31%
ASDSAD	7,904.50	7,904.50	B	100.00%
ZXCZX	7,800.00	7,800.00	B	100.00%

My dimension is Customer Name and the column Class is an  expression If([Exclusive %] <= 0.2, 'A', If([Exclusive %] <=0.70, 'B', If([Exclusive %] <= 0.90,'C',If([Exclusive %] <= 1.0,'D')))). How am i suppose to my this column filterable , so that when i click say one of the class A ...All the class A will shows..As at now, it will only showing one record ...

[Kushal_Chawda]

Go to presentation tab of straight table -> click on Class expression and check "Searchable" option.

[limfungkeat]

Thanks Kushal , apologise for not telling you that i have tried your approach before i posted the question . It just not get filtered correctly . When i did put in the Searchable option and search / click 'A'. The filtered data record is not the same comparewith the original Class A ,before it gets filtered

[zebhashmi]

i can't try it right now, so not sure how it will work

but what about adding a field of Class in Data and filler it from List box

[limfungkeat]

Hi Jahanzeb, the column Class was built base on an expression . It is not a field from any of the table . Tried to do the below , but the field Class is not linked to any of the table / field structure :

CLASS_DEFINITION :
LOAD * INLINE [

CLASS,DEFINITION
A ,   CLASS A,
B,    CLASS B,
C,    CLASS C,
D,    CLASS D

];

[zebhashmi]

r u looking for this

[zebhashmi]

if not then may be you can do

DEFINITION :
LOAD * INLINE [

V1,V2,DEFINITION
0, 0.2, CLASS A,
0.2, 0.7, CLASS B,
];

and use intervalmatch on that.

[Kushal_Chawda]

try like below, create class field in scripr

Data:

LOAD *,

If([Exclusive %] <= 0.2, 'A', If([Exclusive %] <=0.70, 'B', If([Exclusive %] <= 0.90,'C',If([Exclusive %] <= 1.0,'D')))) as Class

FROM table;

Now use this class as dimension in table instead expression

[limfungkeat]

Hi Kushal

Data:

LOAD *,

If([Exclusive %] <= 0.2, 'A', If([Exclusive %] <=0.70, 'B', If([Exclusive %] <= 0.90,'C',If([Exclusive %] <= 1.0,'D')))) as Class

FROM table;

FROM table ...this table is what table ?

[limfungkeat]

The column/ Field [Exclusive %] is not stored in any table, it is constructed base on an expression :

RangeSum(Above(Sum(SALES), 1, RowNo())) / Sum(total SALES)