Let’s define two similar queries for 2004 and 2005. The query for 2004 looks like:
The queries are merged by Service:
Now we want to filter table based on a measure from one of the queries.
Let’s define variable v_Filter as
With the following report filter, the table will show 3 rows and it is expected.
But we will get not quite expected results when one of “non-merged” objects is used.
With .[Service], the filter will remove only numbers that does not match restriction.
With .[Service], the filter will be ignored.
Why? It seems it worked more predictable in earlier versions.