Filter record in a Straight Table based on a calculation Field

Fri, 15 Jun 2012 04:49:02 GMT

Hello everyone,

I got a problem with filter the record out based on a calculation Field. Hope somebody can help

I have a table that contain two mesasure plus one calculation column to show the difference .

Example:

I would like to add a filter on the right for user selection .

If the user select Match , then only the difference equal to 0 will show ,

If the user select Not match , then only the difference equal to 0 will show ,

If not select , all the record show up.

More information:

Because the difference column is calculate based on a aggregated level, i can't per -calculate on loading script

he under level data may be like

Example:

CED Dim1 1 2

CED Dim2 2 1

Any idea ?

Re: Filter record in a Straight Table based on a calculation Field

Anonymous — Fri, 15 Jun 2012 06:26:53 GMT

Not sure how well this will play with more data but you can create a calculated dimension:

=aggr(if(Match='Match' and sum([A Amount])-sum([B Amount])=0,Dim,

if(Match='No Match' and sum([A Amount])-sum([B Amount])<>0, Dim,

if(isnull(Match), Dim))), Dim)

Then just check "Suppress if value is null" for the dimension and it should show what you expect in the example.