Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Management Reporter Help - Can you "Sum" Attribute Columns

Posted on by Microsoft Employee

Hi everyone, 

Until now, I haven't worked any with attributes in Managment Reporter, so bear with me. 

I have a standard profit center report, it breaks apart our different products and their sales. When I drill down on a product, it shows me the account numbers associated with this product and the total amount in those accounts. From here, I can drill down once more to see sales transaction entries and their individual amounts. 

On my column definition, I've now added the following attribute columns. These are allowing me to see the document number (which is the customer id) , descriptions and invoice numbers for these transactions entries. 

Screenshot-_2800_527_2900_.png

I have two questions. 

1. Should I be able to drill down on one of these individual sales transaction entry? MR currently won't let me drill down individually, it only lets me on the screen before (which shows me all of the transactions that have hit an account). 

2. In a perfect world, I would have an interest in summing up sales by a customer - or in this case, the document number (customer id). Is there a way to sum up different attributes like so? 

Thanks in advance for the help. 

*This post is locked for comments

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 229,993 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans