Trying to hide certain rows - i cannot figure out why this is not working

[Tiger1]

I am trying to filter out two rows. I only need/want the rows that have a date to show here. I built another slice to show these two rows - so i do not want them here. However i cannot seem to filter them out.

Here is my raw data table ( i want to filter out “Total” and “Ave Daily Deposit”:

Here is what shows on my app:

[Steve]

Those two rows really shouldn’t be in the spreadsheet anyway. Just remove them.

help.appsheet.com

Working with a Spreadsheet and the Editor

How to understand and control the process of getting your spreadsheet to work well with the AppSheet Editor.

[Tiger1]

I would - however i have another table that references those rows. They change daily so i need to leave them…

[Steve · Accepted solution]

Then your spreadsheets are not well structured for use with AppSheet. Trying to work around the improperly-structured spreadsheets will compound your problems over time. My only advice is to restructure your spreadsheets.

[Tiger1]

ok. Thx

[Tiger1]

Once again you are right… I added a column “Type” and filtered out this way:

Thanks again Steve!