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.
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.
Where as I can pull this exact report in Contour by just adding a 2nd column to group by.
Hi @Nick_Mainella,
I just posted a guide on how to workaround some of the current limitations of the pivot table widget which I think could prove useful to you, if you haven’t found a different solution yet.
While not a direct solution, it should be an easy one to adapt from the one covered in this guide.
Best,
Thank you @sboari. Going to try this with our team and we’ll let you know if we find any limitations!
@Nick_Mainella as I am not seeing this yet in our enrollment, does it come with the option to set the columns collapsible? From your screenshot it doesn‘t look like 
Okay It is now also enabled for us and I can confirm, no expandable column groupings possible 
External Image
