how often adjacent groups are used in SSRS? whether is used in table or matrix more often?

Question

Hello There,

I am trying to find example illustration that explains adjacent groups in table; but couldn't find one. Would any one help me find me that I can stick to get some basic understanding in using adjacent grouping?

Also, I would like to know how often we use the adjacent grouping feature in tablix data region in table and or matrix?

Thank you for giving your valuable time!

Answer 1

Hi @ArunRaaman

I think it depends on the actual data structure. When your data is level down , you don't need to use adjacent group. For example： grade->class->student->course->score

Adjacent group is only required when your groups are parallel.
For example you have a lot of product sales records,when you want to calculate the total sells by YEAR or by Region， then you can create adjacent group.

Here is a video ，you can take a reference：https://www.bing.com/videos/search?q=adjacent+groups&docid=608029835887274195&mid=354A0CF0BC2D72376ED1354A0CF0BC2D72376ED1&view=detail&FORM=VIRE

Best Regards,
Isabella

---

If the answer is the right solution, please click "Accept Answer" and upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.