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.
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:
André Arnaud de Cal...
291,965
Super User 2025 Season 1
Martin Dráb
230,836
Most Valuable Professional
nmaenpaa
101,156