2 Replies Latest reply on May 2, 2015 9:56 PM by danlee

    Problem with List View Layout



      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.

      Thank you