How to display quantity/average transactions of a certain period in Management Reporter for Microsoft Dynamics ERP?

(0) Share

Report

Posted on by Professor_A

Hi, I'm a relatively new user to Microsoft Dynamics. I am currently trying to create a custom report in Microsoft Dynamics Finance & Operations using the "Management Reporter for Microsoft Dynamics ERP" application. Is there any way for me to modify the column definition to display the quantity or average values fetched from my specified financial dimension?

For example, if the financial dimensions fetched for one cell are:

USD 400
USD 200
USD 900

I want the cell to display the average amount (USD 500) or the number of of transactions (which would be 3) instead of the operator I used in the row definition (it would normally display 400+200+900 = 1500 because of my row definition).

I know displaying average/quantity of a transaction is non-conventional for financial reporting, but please tell me if this is possible.

Thank you very much in advance.