hi, thanks. yeah i know that having 'course' in the view is the issue. :-)

my goal is to have ONE envelope per student not one per course. the client needs names, courses and emails all in the view.

i was just hoping there might be a way to get rid of the "extra" marks since each mark is a mail to with the student's email address so i only need one per student.

thanks- but i tried several LOD expressions.... both fixed on 'full name' and exclude on 'course'. they still result in one mark per line.

i'd even tried the below combo and no-go. :-(

{exclude [Course Abandoned]: max({FIXED [Full Name]:MAX([Course Abandoned])})}

i was hoping there was something simple i was missing but i guess not.

i'll try to post a workbook shortly. i have to de-identify the data.

thanks!

here's an anonymized workbook with just that one sheet included.

my sense is that tableau will simply not let you have a text table listing multiple items yet display fewer marks. hopefully i'm wrong.

yes- exactly! thanks so much, it was driving me nuts. :-)