Filtering a table based on a calculated field

[#1]

I have a table e.g.

Engineer	Subject	Created	Days
Engineer Name	Document explaining how to	18/04/2011	27
Engineer Name	report on	27/07/2011	4
Engineer Name	Status Refresh	07/06/2011	1

The "Days" column is a calculated field

I have created a new input box on the Sheet and assign the value entered to the variable $DaysSinceLastUpdate

I would like to filter the rows displayed in the table so that only the rows with a value in the "Days" column that matches the value in the variable $DaysSinceLastUpdate are displayed

So if I entered "4" in my input box the only row displayed in the table would be

Engineer	Subject	Created	Days
Engineer Name	report on	27/07/2011	4

[villafuerte]

Hi,

Maybe you can use Set Analysis in  your expression:

{$<Days={$(DaysSinceLastUpdate)}>}

[#3]

Hi Mark,

See attached file for an example of set analysis, like Villafuerte said. Only, I'm doing =sum(...) instead.

Hope this helps,

Siarhei K.

[#4]

Thank you for the template but I'm using the personal edition also and I'm worried if I import any more qvw files that I won't be able to use it any more.

I haven't use set analysis before...I'll pay around with this a bit more and see if I can get it to work.

[#5]

Thank you for the template but I'm using the personal edition also and I'm worried if I import any more qvw files that I won't be able to use it any more.

I haven't use set analysis before...I'll pay around with this a bit more and see if I can get it to work.

[#6]

Oh, no problem.

Here's the expression for a table that I think would do what you need:

=sum({$<Days={'$(DaysSinceLastUpdate)'}>} Days)