I want to use one query for 5 lists and have the render variable use a 2 part statement to select the data to display. I can get this to work with 5 queries that are all the same except for the filters. The denomination filter changes each list. The rank filter is After Aggregation so that it is ranking the new denomination. The problem with the render variable is that I can't figure out how to get it to work after aggregation with 2 statements in 1 boolean.
I am using the filters: Denomination =0.01 (before aggregation) and Rank <11 (after aggregation).
I am using report studio and version 8.4 with Neteeza.
Is there a way to write:
(Denomination = 0.01) and (Rank < 11, postfilter) as one boolean variable?