Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Dynamics 365 general forum

Create chart of open opportunities on per region and estimated revenue

(0) ShareShare
ReportReport
Posted on by

Hello, i am new to dynamics. I want to create a chart for all open opportunities. In series my selection is estimated revenue and in my category my selection is region (e.g london, bermingham, manchester, etc). Please help me that how do i create those regions for my chart in crm 365 v8.2.

  • Community Member Profile Picture
    on at
    RE: Create chart of open opportunities on per region and estimated revenue

    Thank you i got my work done through this method.

  • Verified answer
    LuHao Profile Picture
    40,886 on at
    RE: Create chart of open opportunities on per region and estimated revenue

    Hi Salman51,

    First of all, there is no region field in Opportunity entity, so you need to create this field first.

    Go to Settings -> Customizations, enter Customize the System.

    7585.4.JPG

    Go to Entity -> Opportunity -> Field, click New.

    6433.2.JPG

    Enter Region in Display Name

    (For better results, you could select Option Set in Data Type and add all region names, this can limit the format of the name of the region entered by users.)

    then click Save and Close.

    2148.3.JPG

    Go to Opportunity -> Forms, double click to enter Opportunity.

    7585.4.JPG

    Move Region field to Opportunity Information column.

    5367.5.JPG

    Click Save and Close. Then click Publish All Customizations. The region field has been created and added to the form.

    Go to Sales -> Opportunities, click Charts on the right. Then click "+" to add a new chart. 

    6254.6.JPG

    Enter the name, select Est.Revenue in Series, and Region in Category. You can also click on the button on the right side of Sum to select the chart type. Click ACTIONS -> Save.

    1682.7.JPG

    This way the chart you need has been created.

    Hope this helps.

    Best Regards,

    Lu Hao

  • Verified answer
    Alex Fun Wei Jie Profile Picture
    33,626 on at
    RE: Create chart of open opportunities on per region and estimated revenue

    Hi,

    There are plenty of available resource over online. You can refer below video on how to create a chart.

    www.youtube.com/watch

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard > Dynamics 365 general forum

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans