Placement of one column details under another column in MR report

(1) Share

Report

Posted on by SantoshB

Hello All

Need your expertise in below requirement.

I am setting up PnL MR report for one of our customer. below is the output format in excel file. We are showing details for each entity wise in the report, 5 entities total and Head office expenses showing separately at the end of the report... finally the report will shows the overall amounts.

I need to show head office expense details under the total column as shown in the screen shot as well as the total balance is sum of all 5 entity + head office expenses. In column definition i set up the columns same like excel file and able to get all the number accurately and the issue with getting HO expenses under total column to match with output format.

Please guide me how to achieve this functionality in the MR report.

I have the same question (0)

All responses (1)

Answers (0)

Charlotte X Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi SantoshB,

I'm not sure if advanced cell placement meets your requirements. Advanced cell placement, or forcing, involves the placement of specific values into specific cells.

Please refer to this MS Doc:

Advanced formatting options in financial reporting - Finance & Operations | Dynamics 365 | Microsoft Learn

Was this reply helpful? Yes No