10 Replies Latest reply: Oct 30, 2013 9:26 PM by CheongWeei Gan RSS

    How to show only a subset of records in a straight table

    CheongWeei Gan

      I have a table like this

       

      YearDeptAward
      2011Finance3
      2011HR2
      2011HR2
      2011Sales2
      2012Finance2
      2012Finance2
      2012HR2
      2012Sales1
      2012Sales2
      2012Finance1

       

      I am trying to setup dashboard for different department.

      How do I display a table that shows only data for specific group, e.g. only Sales data using Set Analysis?

       

      YearDeptAward
      2011Sales2
      2012Sales1
      2012Sales2