Hi All,
I have a report with a simple table in it, which summarizes facts over particular dimensions.
The users want to be able to specify a) the minimum values for summations of the facts (so, for example, don’t display rows where there the value totals less than 100), and b) the N in the top N (e.g., only display 10 rows)
I’ve been able to do both of those things by putting in dummy queries that allow them to specific the Top 10, and the minimum value columns
I then create two variables:
i) IsInTopN - returning 1 or 0,
and
ii) IsGTMinvalue return 1 or 0.
If I put a filter on either of these two variables on the table, the result is as we would want.
but when I put both prompts on, it only displays the rows out of the top N, which also match the mimum value rule. So we might get only 7 rows.
This is probably what I should have expected, but is there any way of specifying the order in which you want the filters to be applied?
(Strongly suspect no :-()
salonika 
(BOB member since 2009-04-06)