1 2 3 Previous Next 32 Replies Latest reply on Oct 12, 2011 7:14 AM by .Yann Treguier

    Applying quick filter from the main data source to the blended one

    .Yann Treguier

      After trying everything I could think of and reading through several posts, I am afraid the following is true in 6.0:

       

      A quick filter from the main data source will only be reflected in the blended data source if the field being filtered is being used on the row or column shelf in the worksheet. 

      Example: to filter both data sources on a region picked from the quick filter, the region field needs to be on either the column or the row shelf.  If it is not, only the main data source gets filtered.

       

      I tried to build a "Region" parameter and a "Region" calculated field in both data sources hoping to set the region to the parameter value.  Same thing.  It will only filter the blended data source if the "Region" calculated field is in view.

       

      I was not able to pick on any workaround in the forum.  Did I miss the magic trick?

        1 2 3 Previous Next