add condition at transform to add report

[Sam_1985]

I want to add report on dashboard to display all patients details into two groups who has civil id and without civil id 

the table of patient details is attached for you . please tell me how to add it?

[anat]

If(isnull(civilid) or len(civilid)=o,'No civilid','Civilid') as newfield

use above field in UI to create 2 seperate reports

[Sam_1985]

HOW TO ADD FILTER AS IF CIVIL ID =0 GIVE PATIENT ID

[Sam_1985]

THIS FILTER AT COLUMN PATIENT ID