Typically, the benefit of collapsing groups is to see the summarized view of a large table, and only expand the ones you need to see. If you have thousands of records, grouped into 100's of groups, you need to be able to collapse the whole table to the groupings (or start off by default collapsed).
This should have an added control for the table to expand all/collapse all.
Comments
It would make sense to have the maker to define on the form the default behaviour:appear collapsedor appear expanded.The user have a menue item to collapse all or expand all as a plus:Have a count at the bottom if collapsed to count the groups. I you use an intersection table like ProductsToOpportunity and you want to see a single list (distinct) of all products added to this opportunity this could be the solution. And then it would be nice to see 75 Products (and 750 ProductsToOpportunity) because for this Opportunity each of the 75 Products has 10 commitments to buy (= 10 ProductsToOpportunity). Any other similar case could be applicable (like "For my B2B Event, from how many different Accounts are my contacts participating (assume the pariticpations are the intersection table between a given event and its hopeful many contacts from N different accounts, some times a dozen of participants/contacts participating from the same large account)? Is one KeyAccount missing to follow up? -> and don't tell to use PowerBI as making a simple list is not "BI" )
Category: System administration
The real WIN would be able to save a view in the collapsed format.
Category: System administration
Comments in this idea brought my attention to the "3 dots", so it's great that the functionality is there, not so intuitive however for someone who is used with pivot tables in excel. :)vote! :)
Category: System administration
thanks Daniel Rosie!! agree its not intuitive at all but at least it works!!
Category: System administration
It's not super intuitive, but you can now collapse or expand all items in a grouped column using the three vertical dots on the right side of the grid header.
Category: System administration
This is a Must. Grouping without "collapse all" is an unuseful feature for large tables.
Category: System administration
Agreed! This feature is needed to promote usage
Category: System administration
Agree with this Idea. Will be a big increase in usability
Category: System administration