Pivot Help

Nathan Umbriac

I have a sheet with a hierarchy broken down by region and country. Under each country is the name of a worker. I'm trying to create a pivot to count the number of workers per region and per county. I've tried is so many different ways and cannot figure out what to select for the rows, columns and values.

Thanks!

Chris Mondeau

Hi @Nathan Umbriac

In my experience, the Pivot App doesn't work super well with Hierarchy, but you might be able to get a work-around by adding a helper column or two to help group items within the pivot.

Alternatively, if you're able to change the sheet structure to remove hierarchy and build a flat table, you might be able to use the new group and summary functions within Smartsheet's reports and avoid the pivot-app altogether.