Please assist in identifying the reasons why the pivot table function within
Excel does not operate correctly. Several pieces of data are missing when
summed, but when you double click on the cell with an empty value it
correctly returns the spreadsheet with found data