Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

KPI

(0) ShareShare
ReportReport
Posted on by

Hello Everyone, Total Sales YTD Detail, where do the figures for the green line Target come from? Jerome Goslett

*This post is locked for comments

  • Community Member Profile Picture
    on at
    RE: KPI

    Hi Natarajan, can you elaborate on how I do this please. Jerome

  • Community Member Profile Picture
    on at
    RE: KPI

    Sorry Mahmoud, it is SSRS Sales, Charts & KPIs, Total Sales YTD Detail. Jerome G

  • Community Member Profile Picture
    on at
    RE: KPI

    Hi Everyone, thanks for your help. Tim this put me on the right track, problem is if I click on the "1" and change it, it spreads the changed figure in a straight line across all months. What I need to do is set a target for each month? Jerome G

  • Suggested answer
    Community Member Profile Picture
    on at
    RE: KPI

    Hi Jerome,

    you can download the deployed report from report server, open the rdl file in Visual studio and see the technical aspects as mentioned by @tim froster

  • Suggested answer
    Tim Foster Profile Picture
    8,515 on at
    RE: KPI

    Jerome,

    It is a hidden Parameter on the Report itself.

    Navigate to the Report on your report server.

    /Home/<Your Company>/Sales/Charts and KPIs

    Hover over the report name. Click on the yellow dropdown arrow and the click Manage.  Click Parameters from the left menu.  Click on the "1" in the Target Parameter.  Change it to whatever you like (remembering your Salesforce and Customers can only do so much).  Click Apply.  View the report again. Done.

    Tim

  • Mahmoud Saadi Profile Picture
    32,738 on at
    RE: KPI

    I am afraid I don't fully understand which specific reporting and BI we are talking about in here, is it the business analyzer ?

    Further details are appreciated,

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

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Almas Mahfooz Profile Picture

Almas Mahfooz 3 User Group Leader

Featured topics

Product updates

Dynamics 365 release plans