Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX (Archived)

Management reporter linked to Excel

Posted on by Microsoft Employee

Hello community,

Please how can i combine 4000  and 2300 in April, and 4500 in March from Excel Data to MR report ?

2543.AZER.jpg

Thank you,

*This post is locked for comments

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Management reporter linked to Excel

    Hi,

    What kind of report is this that you try creating?

    Looks as if you want to import some invoice related data.

    Can you provide some additional information on what you try to achieve?

    Many thanks and best regards,

    Ludwig

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Management reporter linked to Excel

    do you mean in the Excel sheet?

  • Abishek Profile Picture
    Abishek on at
    RE: Management reporter linked to Excel

    You need to map the cells that you trying to add from excel in MR also.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Management reporter linked to Excel

    Yes but what changes should i make in row definition and column definition?

    Thank you,

  • Abishek Profile Picture
    Abishek on at
    RE: Management reporter linked to Excel

    When you linked excel sheet to MR did you have to mention which cells would go where in row definition or column definition if yes then I guess you need to make some changes in that report.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Management reporter linked to Excel

    Hello,

    I mean the total of 4000+2300 and every amount in the month of April should display on the report next to FD data in April. And the same thing for other amounts in other months.

    Thank you,

  • Abishek Profile Picture
    Abishek on at
    RE: Management reporter linked to Excel

    @Imane.Iam what do u mean by combine? can you be more specific what you want achieve ?

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans