2 Replies Latest reply on Jul 8, 2012 2:05 PM by George Ricco

    Using a filter to exclude one record in a dimension (but not in another)

    Melissa Schuurman

      I'm creating a dashboard showing how many courses students take per semester, looking at overall total and breaking it down by faculties.

      I'm trying to find a way to display how many students that are enrolled in one faculty take courses that are offered outside of that faculty (i.e. Faculty of Arts student takes 2 courses offered by Faculty of Science, 3 by Business School, etc.) without including the faculty that the student comes from.  As shown below.

       

      Faculty of Arts  

                      Faculty of Human, Soc & Ed Dev  

                      Faculty of Science

                      School of Business & Economics

                      School of Nursing

                      School of Tourism

                      School of Trades & Technology

      Faculty of Science  

                      Faculty of Arts

          Faculty of Human, Soc & Ed Dev      

          School of Business & Economics

          School of Nursing

          School of Tourism

       

      So when Faculty of Arts is the faculty that a student is enrolled in, it doesn't show courses taken that are offered by the Faculty of Arts, but Faculty of Arts shows up for the rest of the faculties.

       

      Hopefully this makes sense.