Pivot table filters old data?

Pivot table filters old data?

Hi! 

So to explain this easy: 

I have a form with columns and rows. The row has numbers (ID) and a column value which can be set to true or false. 

Entry with ID 1 has the column set to FALSE. 

When I filter the pivot table that I only want to see the entries which are marked as TRUE - it shows up. As TRUE! Even though it is not. 

  • In the Zoho Report popup Windows the value is TRUE 
  • But when I check the list - Its FALSE
Seems it has cached some old data? Is there a way of fixing this without having to go into each value and reset it? 

/V