Hello. I have a question about pivot tables for the workshop. I’m trying to create a table like the one in the attached image, but I’m worried that the hierarchical combinations of “region” and “product” will be difficult to see.
I’d like to implement a table like the image, where it’s clear that “region” is grouped and “product” is aggregated within each group. Is there a way to achieve this with the pivot table widget?
Thank you
how about using summary contents? It is beta version, but It is really good at structural, hierarchical visualization.
@Hogehoge the pivot table functionalities are unfortunately not first class. If you are bound to this structure you took the most out of it for your case (for now). One idea I would have would be to switch the column and rows if you’d the months on the column grouping you could set the row grouping to be expandable. Then you would get the hierarchical separation of region and product
@fac7a5bb66119b7b9c34 i am intrigued about the content summary widget. Could you share how that looks and what the purpose is?
This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.
