Summary by Client

ABratton

I created a ticketing process and the result is a list of tickets in a sheet. I want to be able to report on tickets by client. I am trying to avoid maintaining a list of clients for the report. In excel I would use a pivot table, I am trying to avoid needing that addon. Is there a way to take a list of data and summarize it by a column, when I don't have a pre-defined list of what is in that column?

Thanks.

AnthroTim

Hi,

I wonder if 'Group' and 'Summarize' on a Report would give you what you need.

You can use that to group data in a report by a column or columns and also summarise the data (giving you ticket counts etc).

https://help.smartsheet.com/articles/2482082-configure-grouping-to-organize-results-in-report-builder

https://help.smartsheet.com/articles/2482083-summarize-content-to-extract-key-information-with-report-builder

Tim

anthrotechnic.com