Hello everyone!! My question concerns filters. I am using a complex formula in a measure. The measure will either return null or a value. I am trying to filter the null values. I do not have filter capability on the measure. Let’s call the measure “C” .
I really would rather avoid the prompts. If anyone can tell me how I can get my filter to work on “C” on the report level; I would greatly appreciate it. I can filter on other measures. I just can not filter on the measure with the complex formula behind it.
Highlight the entire Crosstab and go to Format -> Filters. Click Add and then select the object represented in your vertical column. Highlight A, B, D, F from the list and click OK.
You should be able to create a “TOTAL” Field that sums up 1-6 (easily done if this is a crosstab). Then filter your tables to only show those that have a “TOTAL” <> 0.
You can create a total using context, but do NOT use the sum() function. If you do, you will find out that you cannot filter an aggregate function. Aggregates are done after the filtering, and therefore are not valid in a filter expression.
You might be able to do this with a subquery. There is an example of just this type of problem in my most recent “Variables” presentation at our web site.
In a message dated Tue, 7 Nov 2000 1:27:39 PM Eastern Standard Time, Robert digpen@CONWAYCORP.NET writes:
<< Kaylan,
You should be able to create a “TOTAL” Field that sums up 1-6 (easily done if this is a crosstab). Then filter your tables to only show those that have a “TOTAL” <> 0.
Can anyone help me to tell a way to apply a filter on a formula. I defined the forumula as a variable. Now i want to apply a filter for that variable. How to do it? In the same way, is it possible to hide a row based on certain value?