Report Builder

Hi everyone, Looking for some help with report building. In my sheet, I have a "Category" column. In that column, each row is assigned one of four values (Risk, Dependency, Issue, or Assumption). I want to have a chart widget on my dashboard that counts how many rows fall into each category. It's my understanding that this is easily done by building a report and then a widget that summarizes the data. How do I build a report that shows a sum of each category option instead of pulling in the column and providing a total sum as pictured below?

I need one row in the report that has the sum of each of the 4 categories

Best Answer