Set analys

[Vittore8]

hi, if i use

Select column1 from table Number where column1 = 9;

result: 

column1
9

9

9

how to get a similar result, but using set analysis? 

[agni_gold]

if you are looking for dimension  , you can simply do as calculated dimension : 

if (column1 =9 , column1 , null()) 

after that do the suppress null 

[HirisH_V7]

Sum({<column1 = {9}>} Sales)