Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ...
Go to presentation tab of straight table -> click on Class expression and check "Searchable" option.
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
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
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
];
r u looking for this
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.
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
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 ?
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)