How can i filter the data

[#1]

Hi guys,

Column 1	Column 2
A	1
B	2
C	3
D	4
E	5
F	6
G	7

From Column 1 i just want to see A, B, C in the report.

So how can i filter the data ? Where i need to write the expression ? And can you please provide me the expression ?

Please help

Thanks.

[Anonymous · Accepted solution]

you can use calculated Dimension: if match(Column1,'A','B','C')> 0, Column1)

or

set analysis

sum({<Column1={'A','B','C'}>}Column2)

[trdandamudi]

Please see the attached for the solution:

[#4]

you can use the calculated dimension in this case in front end. in dimesion you can write expression as below:

if(match(Column1,'A','B','C'),Column1)

then check option to supress null values.

But it is better to do this at script level if possible or else create a flag in script for values as A, B and C and use this flag in calculated condition. it will be better performance wise as compare to above solution

[miguelbraga]

See the attached file

Regards,

MB

[#6]

Try this girishinani

Dimension : Column1

Expression :sum({<Column1={'A','B','C'}>}Column2)