Detailed summary reports for multiple fields.

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered

I am attempting to create a summary report but having some issue. My database has a field for analyst (multi choice) and multiple 'skills' fields, each one is multi choice (can perform, cannot perform, can train, etc). Is there a way to create a summary report that lists the fields as the rows but only shows a count in column under each multi choice answer? (the count would be how many analysts are marked as Can Perform for Unit testing as an example)

Photo of Niki

Niki

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of Matthew Neil

Matthew Neil

  • 31,678 Points 20k badge 2x thumb
Niki, 
If you are still stuck on this let me know.  But you should be able to do this by setting the grouping by the skills, and then summarize multiple skill answers.  When you hover over the line "Item to summarize" a green (+) plus sign will appear, and you can add more rows or columns depending on your grouping goals.

(Edited)