0 Replies Latest reply on Oct 23, 2012 8:27 AM by Sharon Sanford

    Can you filter your secondary datasource on a worksheet with blended data?

    Sharon Sanford

      I am trying to apply a filter, which only applies to my secondary datasource on a worksheet, and it does not seem to be working.  I have a dimension common to both datasources on my worksheet and the relationship is definied with for this dimension.  Then I have a metric from the first datasource, and another metric from the second datasource.  I want to filter the metric from the second datasource on a dimension that is unique to that second datasource, and all my data disappears when I apply the filter.  If I change my secondary datasource to primary, I can filter on it.  However, it is not showing all the values from the dimension that I would like it to show since it is being filtered on.