1 Reply Latest reply on Apr 24, 2013 12:00 AM by Gareth Jones

    Can I count records twice in a single dimension?

    Gareth Jones

      Hi

      Sorry, the title is probably a bit wrong, but I couldn't really figure out a way to ask it in a sentence.

       

      Basically my data is as this:

       

      Record ID QUESTIONRESPONSE
      1GenderMale
      1Age Group20 - 30
      2GenderMale
      2Age Group20 - 30
      3GenderFemale
      3Age Group30 - 40
      4GenderFemale
      4Age Group30 - 40

       

      I am trying to view the data as such:

       


      20 - 3030 - 40
      Male22
      Female22

       

      Is this possible?

       

      Any help would be greatly appreciated!