1 Reply Latest reply: Jun 15, 2012 2:26 AM by Johannes Sunden RSS

    Filter record in a Straight Table based on a calculation Field

      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:

       

      2012-06-14_190014.jpg

       

      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 ?