web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Customer experience | Sales, Customer Insights,...
Answered

Parent and child account relationships

(0) ShareShare
ReportReport
Posted on by 15

We are currently using the OOB parent account functionality in CRM. But the business leaders think it is not getting used as it should be.

For example- they want to see hierarchy of a parent and child accounts but would also like to see the number of case volumes or tickets rolling up in the parent account.

When we create a query to show volume under X parent account it excludes the volume in parent account and gives the result for only the child accounts.

How can we address these two situations?

Thank you,

Riddhi

I have the same question (0)
  • LuHao Profile Picture
    40,888 on at
    RE: Parent and child account relationships

    Hi Riddhi,

    Can we use the same logic for tickets/complaints?

    - If the relationship between Account and tickets/complaints is 1:N, yes, the logic is same.

    How can we show the cascading to different children accounts?

    - Can you provide a screenshot to show the effect you want to achieve? 

    The rollup field summarizes the data of all child Accounts of the current Account by default. If you want to summarize the data of certain child Accounts, then we need to add a filter to the logic of the rollup.

  • Ridhi210 Profile Picture
    15 on at
    RE: Parent and child account relationships

    HI Lu,

    Thanks for your reply. Can we use the same logic for tickets/complaints?

    This will address the roll up part but how can we show the cascading to different children accounts?

    Appreciate your reply.

  • Verified answer
    LuHao Profile Picture
    40,888 on at
    RE: Parent and child account relationships

    Hi Riddhi,

    So we can create a rollup field to show Case volume of the current Account as well as child Accounts.

    pastedimage1616738823549v1.png

    Then edit the rollup logic as follow.

    pastedimage1616739098254v2.png

    So it will count Case volume of both the current Account and its child Accounts.

    pastedimage1616739154238v3.png   pastedimage1616739175109v4.png

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
DAnny3211 Profile Picture

DAnny3211 126

#2
Daniyal Khaleel Profile Picture

Daniyal Khaleel 117

#3
Abhilash Warrier Profile Picture

Abhilash Warrier 70 Super User 2025 Season 2

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans