Expression looking at a slicer

[GavinDJ]

Hi,

Is it possible to build an expression that is looking at a slicer?

e.g. I have a list of income for all time and from here I have used slicers to create 2022, 2023, etc.

Within a different table, I want to create a virtual express that only looks at the 2022 slicer. 

Currently, I've created an expression that looks up the main table and uses Filter, however, I have a feeling that this is not the most efficient way to build.

Thanks for your help.

Gavin

[Marc_Dillon · Accepted solution]

Just replace the table name in your expression with the slice name.

[Marc_Dillon · Accepted solution]

Just replace the table name in your expression with the slice name.

[Swoopy · Accepted solution]

Slices are treated like tables in AppSheet's expressions.