Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
you can use calculated Dimension: if match(Column1,'A','B','C')> 0, Column1)
or
set analysis
sum({<Column1={'A','B','C'}>}Column2)
you can use calculated Dimension: if match(Column1,'A','B','C')> 0, Column1)
or
set analysis
sum({<Column1={'A','B','C'}>}Column2)
Please see the attached for the solution:
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
See the attached file
Regards,
MB