Thanks for following up on this issue, @gwizard!
What you shared definitely makes sense. When I forwarded Becca’s suggestion to my team, we were also aware that Pivot Table should cater for collapsing all types of groups and sub-groups. Very much aligned with you on this.
Unfortunately though, we haven’t been able to get to this implementation in the last months. It’s since we were focusing on Canvas Dashboard and the overall as-code experience at the time.
That said, I just checked with the responsible team and we do plan to get back to this in the near future. We’ll keep you posted when there’s a more concrete plan. Cheers!