Pivot Help

Nathan Umbriac
Nathan Umbriac ✭✭✭✭✭
edited 06/14/22 in Add Ons and Integrations

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.



  • Chris Mondeau
    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.