This is possible by configuring expandable or hidden columns in the Pivot Table widget. The below screenshots show an example where a user can set the visible column to year or month or expand from year to month, week, and day. One wild caveat is that these columns can’t be renamed in a pivot table.
Thanks for the solution, this is definitely interesting.
Not exactly our use-case though, let me share some more details : we have a pivot table with row groupings like product category, warehouse logistics center etc…
And our columns are month / week or day.
We currently have one pivot table with Month columns, one with Week columns, and one with Day columns.
The idea here would be to be able to configure the time interval of the column grouping dynamically in the UI