Summarizing a Report by value count in a table

brianne111081

I created a report combining several different sheets, and I am trying to create (anywhere) a table that can count each topic from that combined report. Id like the table to keep updating as new topics are added.

For example:

Respiratory System | 1

Endocrine Systems | 1

Behavioral Health | 5

Thank you!!

SoS | Dan Palenchar

You could create a chart off of the report and put this on a dashboard.

If you want to get the sum total of topics from multiple sheets, I'd recommend a separate metrics sheet that uses cross-sheet COUNTIF formulas to sum the applicable items from each sheet into one total. You could pull this data into the report or more elegantly organize it on a dashboard.