-
1. Re: Filter with Multiple Conditions
Keith Troutt Jul 19, 2017 1:58 PM (in response to Thiago Alpoin)Hi Thiago,
Try this calculation:
CONTAINS([Pricing Condition],'x')
And [Current Situation] = 'Yes'
Add it to your filter shelf and select true.
Thanks!
Keith
-
2. Re: Filter with Multiple Conditions
Thiago Alpoin Jul 19, 2017 2:45 PM (in response to Thiago Alpoin)Hi Keith Troutt
Thank you so much for your prompt reply and help on this.
However (and my apologies for that as I may be not so clear on my question), that's not the solution I was looking for.
My data is just a small sample of my database. My data is linked to a SQL server data, and I would like to extract the data before start my work in a worksheet.
It's almost like a where clause so I can only work with the data that interests me so I can improve performance in my calculations.
I was referring to filter in the data source tab before start my work in the worksheet. And that's where I'm getting the error.
Any suggestion?
Again, I highly appreciate your attention and help on this. This puzzle is killing me!
-
3. Re: Filter with Multiple Conditions
Zhouyi ZhangJul 19, 2017 10:16 PM (in response to Thiago Alpoin)