4 Replies Latest reply on Apr 10, 2013 12:20 PM by david.millrod

    How can one quick filter for a dashboard apply to sheets with two different data sources and a common field?

    david.millrod

      In v8 I can apply a filter to all worksheets using a given data source.  I have a dashboard that spans multiple data sources that have a common field (date) and a single quick filter that should apply to the entire dashboard.  The only solution I can think of is a messy one - joining all of the tables referenced in any dashboard elements into a single data source.  Not terrible, but messy.  I was trying to see if somehow data blending would be cleaner.  In a given sheet I'm thinking I'd need to grab the date from the irrelevant data source and do something with it, but that's as far as I've gotten.  For now I'm going with the messy solution of a combined data source...