1 Reply Latest reply on Nov 29, 2013 7:30 AM by Mark Jackson

    Filter only applying to shared dimension between two data sources


      i added a chart from another workbook via bookmark, and am trying to keep the data intact on the same sheet, but the filter is only working for the shared dimension (blue), even though the criteria (i.e., selection: all + wildcard: contains "trial") are met for second data source too. is there any way to overcome this limitation with the filter? and if so, can i then combine the two charts on the left into a single bar chart?


      the data sources have identical fields, but too many fields for union, join, etc. and is an excel workbook (xlsx).

      bookmark issue.jpg