Skip to main content

Notifications

Microsoft Dynamics RMS forum

Report for sales by categories?

Posted on by Microsoft Employee

I want to do a report that shows sales for the last year for each category.

Ideally, it go:

Overall -> Departments -> Categories

I don't want to see individual items.

I haven't found the right report yet in RMS. I get can get department totals easily, but getting a single report with all categories . . . I'm striking out.

Any suggestions?

Thanks!

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Report for sales by categories?

    Thanks, RMS Wizard! Perfect!

  • Verified answer
    RMS Wizard Profile Picture
    RMS Wizard 1,205 on at
    RE: Report for sales by categories?

    Manager, Reports, Sales, Detailed Sales, define date range, OK to run.

    Click Collapse icon in chat toolbar to view totals by Dept.

    To do same for Categories either select Grouping icon in chat toolbar (second icon) and select "Group first 2 columns", or drag the Category column title to the left most column on the report.

    You can also right-click on the report, select Show/Hide, and remove Dept column (as long as it is not first column).

  • coupet Profile Picture
    coupet 205 on at
    RE: Report for sales by categories?

    If report is not available, you have the option to create your own reports as desired using Reporting Services (SSRS)

    technet.microsoft.com/.../ms159106.aspx

    Darly

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Report for sales by categories?

    No suggestions? This seems like it'd be a standard report.  Does it not exist?

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

News and Announcements

Give Back to the Community this Month

Quick Links

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

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,807 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,135 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans