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