3 Replies Latest reply on Jun 3, 2013 8:04 AM by Elena Barmina

    How can I exclude nulls from a filtered result set?

    Elena Barmina

      Hi,

       

      I'm trying to create a global filter for a dashboard that is built with worksheets on two data sources.

      What I did:

      1. Created a parameter that I want to use as filter.

      2. Created a calculated field that I want to filter the report with.

      What I observe when I apply the parameter to the data is a list of nulls in place of valued for which the filter is not applied.

       

      Is there a way to exculde those nullls and make the report to only show the filtered values? That is, I would like to have only the filtered values to be shown, the selection changing when I select a value in the parameter.

       

      Thanks in advance!