When I double click on a pivot table the new spreadsheet shows a broken data set

When i uncheck the filter option it populates the data. Running the same sheet in the online excel program the action works correctly.  (double click on sum data, new sheet is generated and data is p...