Try this calculation:
And [Current Situation] = 'Yes'
Add it to your filter shelf and select true.
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.
Again, I highly appreciate your attention and help on this. This puzzle is killing me!