Pivot Tables with Multiple Columns

Hello - I’m trying to create a pivot table in Workshop with more than 1 column group

There is no option to add a 2nd grouping for columns once on is selected. The current work around is having 2 pivot tables next to each other in workshop which doesn’t look good or work efficiently. I haven’t found a real workaround besides creating the table in Contour.

This will help our finance team create future projections if we could look at one table displaying monthly totals by currency.

Can you select “Add Grouping” button? See attached

There is only an option to add more row groupings but this needs to be done on columns.

I cannot create a report in Workshop that shows estimated payments in columns with 2 currencies.

image

image

Where as I can pull this exact report in Contour by just adding a 2nd column to group by.

image