2 Replies Latest reply on Oct 12, 2012 12:10 PM by Ralph Lindenfeld

    dashboard filtering

    Ralph Lindenfeld

      Folks-

       

      I'm trying to mock up a fairly simple dashboard. Sheet one shows an overview of one of four summary measures, which can be chosen from a single-pick menu (BTU, Managed Flows, Total Parts, Total QXJT). Sheet two should only show 1) values associated with one of the four prior picked (I need to be able to explicitly set these relationships), and if a point on the sheet 1 menu is picked, filter the results further (this part I have gotten to work).

       

      For example, if Total Parts is selected in Sheet 1, only JXT Parts, QJ Parts, OG&GPT Parts would be shown in 2.

       

      Right now, the filter for Sheet 1 is a quick filter - I would like to restrict this to only the four values (above).

       

      Any help would be appreciated..

       

      -RL