9 Replies Latest reply on Mar 22, 2011 4:43 AM by Joe Mako

    applying quick filter on worksheets with different data sources

    Rohan Dhanashri

      I have 2 worksheets on a dashboard which have different data sources. I want to show one quick filter which will filter both of these. My data looks something like this -

       

      Measure1, Measure2, Measure3, Measure4, Value1, Value2, Value3

      A, I, P, X, 1, 1, 1

      A, I, P, Y, 1, 2, 2

      A, I, Q, Z, 2, 2, 3

      A, J, P, X, 3, 2, 2

      A, J, P, Y, 1, 3, 4

      B, J, P, Y, 2, 2, 2

      B, K, Q, Z, 4, 3, 2

      B, K, P, Y, 3, 3, 2

      B, L, Q, W, 2, 1, 3

      B, L, Q, Z, 3, 4, 2

       

      and

       

      another one where i have 3 measures -

      Measure1, Measure2, Measure3, Value2, Value4, Value5

       

      The quick filter needs to be applied on measure 1 and measure 3 on both of these. How do I do that?