Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Customer experience | Sales, Customer Insights,...
Suggested answer

Group By for all pages

(0) ShareShare
ReportReport
Posted on by 1,027

We need to use functionallity of grouping data in view.

Looks like standard functiionality works only for 1 page

Here is the sample. I have 70000 rows with different plants

2020_2D00_03_2D00_20_5F00_08_2D00_12_2D00_34.png

Here is the result of grouping

2020_2D00_03_2D00_20_5F00_08_2D00_15_2D00_32.png

Is there any ideas?

  • Suggested answer
    RE: Group By for all pages

    Hi Andrey,

    Thank you so much for your response. 

    We understand your concern here. You can share your ideas in the links https://experience.dynamics.com/ideas/ so that i might be made available in the future releases. 

    Thank you!

  • Kipetcoff Profile Picture
    Kipetcoff 1,027 on at
    RE: Group By for all pages

    Hi,

    Thank you for the answer. Unfortunately there are to much rows in this tables and next page the same as first and next and next. I got the idea that but as you understand for enduser this logic is not suitable

  • Suggested answer
    RE: Group By for all pages

    Hi Andrey,

    I tried the grouping in my test environment. 

    When you perform the grouping for a view, it groups for the complete data by the view alone is at page level of 50 or based on your page limit.

    In the above screen shot, when you move to the next page you will be able to see the continuation of the grouping.

    For example if you have 200 total records, with records under Group A (100 records) , Group B ( 50 records), Group C ( 25 records ) and Group D (25 records)

    With the view page limit of 50 records below will be the grouping.

    In the first two pages, you will be seeing only Group A, in the third page Group B and in the fourth page it will have Group C and Group D.

    As per the details and image shared above i would request you to move to the next page to confirm the same. 

    Please mark the reply as verified if the details has helped you.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,356 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans