Count Distinct with Null Value

building reports webintelligence legacy
1

Hello,

If the data is available as below, I would like to only display the values that are not similar.

Column 1, Column 2
A, 1
A, 1
A, 1
A, 2
A, #

I only need to display the last two rows where the Column 2 values are 2 & #.

Please help me on how it is possible in WEBI. I am building this WEBI report on a BEx query.

Thank you all in advance.

sapduniya (BOB member since 2012-12-28)

2

what is the logic to determine which rows to pick? otherwise you could just filter on the values 2 and # if hardcoding works in your case. otherwise you will need to build a variable with the logic to determine if you want that row showing. i suggest having the variable return a 1 if your conditions are met and 0 if not and then filter for 1 values of that variable in your block

erik.stenson :us: (BOB member since 2012-07-30)