Filter record in a Straight Table based on a calculation Field

[#1]

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 ?

[Anonymous]

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.