Apply a filter without Filter pane

Anonymous — Thu, 24 Aug 2017 14:46:51 GMT

Hello, i'm new and I have a huge blocking point ... I hope someone will be able to help me.

I would like to know, if it possible to apply multiple filters on a table without adding a filter pane

My example :

Table_1

{cars

dogs

cats}

I want to apply a filter with

cars = 1,

dogs between 5 and 10

and cats not equal to 3

Only one time, before extracting or just after extracting BEFORE creating my Sheet.

Do you thing there is a way to do it ?

Thank you very much for your time.

Re: Apply a filter without Filter pane

sunny_talwar — Thu, 24 Aug 2017 15:38:14 GMT

May be use set analysis here

Assuming your expression is Sum(Measure), try this

Sum({<cars = {1}, dogs = {'>=5<=10'}, cats -= {3}>} Measure)