Can you post a sample workbook that demonstrates this? The '...' means there is more data there to display, right?
If you can't post your production workbook, mock up a sample using the sample data provided and try to replicate this issue using that data. I believe there's a simple fix, but I'd need to see it in play to help you--someone else may be able to advise you without a workbook, but a workbook is always the best way to get help!
I'm almost certain you're using Tableau v8, in which case you no longer need IIF(FIRST()==0,LAST(),0) optimization. You can get rid of the ellipses in two ways. One is to Ctrl+Draga copy of the table calc pill onto the Filters Shelf and filter for non-Null values, the other is to use Analysis->Stack Marks->Off.
Thanks guys it worked I am using tableau 8 so I will remove the useless optimisation as well.