How to set group by in drupal 7 views?????????
Do you want a grouping field such as :
Type 1 Row 1 Row 2Type 2 Row 3 Row 4
If so, use the Format Settings to select a Grouping Field.
If you want to use COUNT() or SUM() aggregation, change "Use Aggregation" under the Advanced settings.
do the following:
or check this link:http://drupal.stackexchange.com/questions/4770/how-do-i-group-elements-i...
Drupal Developer, Yaab
I am actually trying to do something same but I have a View in Drupal 7 of type Content, instead of fields. Views can be of types Content and fields; for fields type of View, these options are surely available but for View of type Content this option isn't available for me at least. I am trying to figure out how to add Grouping in this case, when this option isn't there as I am using View of type Content instead of fields. Just to clarify, when I modify my View to be of type fields then that option becomes visible, and as soon as I modify the node to be of type Content(like showing whole nodes) that option goes away. Trying to figure out a way to do Grouping in this case, any sort of help would be greatly appreciated.
You can group by a field but still show the Content node or teaser. To do this, use the Fields setting. Add a the field that you will be grouping on and exclude it from display. Then add Content: Rendered Node as a field. You can set this field's setting to Display = "Show complete entity" and View mode = "Full Content" or teaser. Then set the grouping field to the first field you added.
Drupal is a registered trademark of Dries Buytaert.