How do I create a grid summary report with data and not numbers?

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
I have a table that lists certifications for employees. 

Each record contains the employee name, the certification name, a ertification date, and expiration date and a level.  Levels are formatted a text because they are sometimes numeric but other times letters.

 I would like to create a grid report with employees in the rows, columns for each cert name, and have the level displayed in the grid body.  How would I do that?

Photo of George

George

  • 0 Points

Posted 2 years ago

  • 0
  • 1
Photo of Matthew Neil

Matthew Neil

  • 31,698 Points 20k badge 2x thumb
From the looks of it, you are looking to make a table report, but with some styling that will help present the data the way you need.

Start with the columns set as:
- Employee Name
- Cert 1 
- Cert 2
- Cert etc,

Then you can set the sorting as
"Sort & Group from low to high by" then pick your 'employee name'.

There are a few different tweaks you can make to get the styling and appearance you need, so just play around with it until you get what you like.