Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Unanswered

Placement of one column details under another column in MR report

(1) ShareShare
ReportReport
Posted on by

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.  

pastedimage1679552456582v1.png

  • Charlotte X Profile Picture
    Charlotte X on at
    RE: Placement of one column details under another column in MR report

    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

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,965 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,836 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans