5 Replies Latest reply on Feb 15, 2018 6:52 PM by Zhouyi Zhang

    Survey question calculation

    pradeepbangarusamy

      I have given below the dataset and am trying to create a output like below. am not sure how to do that. can anyone help me on this

       

       

      I am trying to display how may people answered all the question yes and then two question etc...

       

       

       

      Output
      YesNo
      All questions
        Answered
      21
      two questions21
      One questions12

       

       

       

      QuestionPersonAnswer
      Question1Person1Yes
      Question2Person1No
      Question3Person1Yes
      Question1Person2No
      Question2Person2No
      Question3Person2Yes
      Question1Person3Yes
      Question2Person3Yes
      Question3Person3Yes
      Question1Person4Yes
      Question2Person4No
      Question3Person4Yes
      Question1Person5Yes
      Question2Person5Yes
      Question3Person5Yes
      Question1Person6No
      Question2Person6No
      Question3Person6No