Dynamics Community Forum Thread Details

Management Reporter Help - Can you "Sum" Attribute Columns

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.

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.

Quick Links

Leaderboard