Problem with List View Layout
I have a layout in List View. I have a field, Trainer. I only want to show Trainers in that layout when they have Active clients. I created a calculation field, Case ( ActiveNumber ; Trainer ), ActiveNumber is a calculation field, Count ( Clients|Active::_fkTrainerID ), and it gives me the trainers who have Active clients but it leaves spaces as you can see in the attachment. I don't want those spaces. The empty spaces are all the other trainers in the database. How can I write it up to just show only Trainers with Active clients without all the empty rows.