Filter on Expression in a Straight Table

[#1]

Here is the scenario:

Product (dim), Sales (dim),

Plan(dim),

Sales - Plan (expression - calculated within the Straight Table)

A, 1000,	800,	200
B, 300,	800,	-500
C, 100,	50,	50
D, 5000,	2000,	3000

I have a slider object on the screen with Min and Max variables to filter the (Sales - Plan) range.

Is it possible to have a filter on an expression (Sales - Plan) within the straight table? If yes, how do I implement.

Thanks in advance!

[swuehl]

Have you tried something like this as expression

=If(Sales-Plan >= vMin and Sales-Plan <= vMax, Sales-Plan)

If the 'supress zero values' is enabled on presentation tab, it should filter your chart accordingly.