Expression to filter a slice

[kaium156]

Hi,

I want to create a slice based on some specific row-column. I have a table with columns - Invoice Date, Start Date and End Date. I want to filter data based on the value of Row # 2 of Column Start Date and End Date. How can I refer to this specific Row and column in my filter expression?

Thank you very much.

[Marc_Dillon · Accepted solution]

Maybe this:

ANY( SELECT(
  table[column] ,
  [_RowNumber] = 2
) )

help.appsheet.com

SELECT()

Gather column values from row in table or slice

help.appsheet.com

ANY()

One arbitrary list item

[kaium156]

Marc_Dillon:

ANY( SELECT(
  table[column] ,
  [_RowNumber] = 2
) )

Thank you very much. This is the expression I was looking for.