Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
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.