Missing values in pivot table

Riny_van_EekelenI have been having the same issue. I have a data table with various date/text columns and an amount column. Where there is an entry with two duplicates either in the date, the text or the amount row, these sometimes appear with blank data or missing entirely. I have included screenshots of the data table, the pivot table with the data missing and one with the text amended to make the data show. This is totally impractical for the main pivot tables as there are duplicate monthly amounts for various accounts and I am having to amend each entry in the data table to ensure they show.

I have tried to change the field settings for "Repeat item lables" for the whole table in the "Design" Tab, but this doesn't work.