Missing rows in table visual

i have table visual having 5 rows of data from database and i used these data to view on report.But ,these all 5 rows are not showing in table visuals and in data export excel sheet also.Only 4 row are there.I go through it and i found like missing row is combined with one of the row which is already there..So,4th and 5 th row combined and showing as one row in my report.In each row some value are text and some are wholenumbers.So,4th and 5th row text fields are same and numbers are same.So ,after combine showing row is viewing like number fields from 4th and 5th row are added together value is showing.One column primary key value is there in data .But i didnot taken primary key  in table visual.If i taken that primary key to my table visual means all 5 row will show else it show only 4 row with two row combined row .

Data view

Report view

here i didn't used primarykey column.So ,here two rows are combined together showing as result

If i used primary key as field without summarized report is viewing correctly.I didn't understand what the reason ?plse help for the solution.Actually i need report without using pk column .