Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
May be use set analysis here
Assuming your expression is Sum(Measure), try this
Sum({<cars = {1}, dogs = {'>=5<=10'}, cats -= {3}>} Measure)