7 Replies Latest reply on Apr 24, 2013 6:34 AM by Justin Smith

    Compare Rows within Dimension Results on Crosstab

    Justin Smith

      Hi everyone,

       

      I've got a cross tab that has numerous dimension showing a listing of students. I have them grouped by an individual ID, and for each row there is a Date Added field. I need to put each person that enrolled before and after a certain date on separate pages of the cross tab. I've got all that figured out by using pages and a calculation that compares date to the date in question.

       

      The problem I'm having is I need a third page showing students that added a class before the date and one after. For the life of me, I can't figure this out. The third page should only have students that have at least one class after the date and at least one before it.

       

      Any thoughts are appreciated.

       

      Justin

       

      Message was edited by: Justin Smith Title changed to be a little more meaningful.