I believe the Category, Sub category, and product names associated with item no 40.260.709 have no values to sum therefore are null and are not showing in your straight table. Mimic the straight table in a table box and look at the results. Note you can't do any aggregations(sum) in a table box.
Check whether you are joining any tables to fields to this fields, or check whether there is data for this values or check whether you are joining the tables with the correct fields. If nothing worked can you attach sample application with data.
Thanks for the reply. I did jointed the tables with the correct fields. As below, if choose another 40.251.705, the information on same fields appeared. I have 2 source excel file, 1 file with area, itemno, product name and sales qty, 1 file with itemno, product name, category and sub category. I checked there are values for 40.260.709 in both 2 files.