Filter on Expression in a Straight Table

Mon, 07 Mar 2016 22:06:56 GMT

Here is the scenario:

Product (dim), Sales (dim),

Plan(dim),

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

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!

Re: Filter on Expression in a Straight Table

swuehl — Mon, 07 Mar 2016 23:57:11 GMT

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.