Skip to main content
Dynamics 365 Community / Forums / Finance forum / Create a custom ER for...
Finance forum
Suggested answer

Create a custom ER format by using group in Excel

editSubscribe (0) ShareShare
ReportReport
Posted on by 2
Hello all,
 
Anyone can assist me to how to create a custom ER report by using group in excel
 
Line numIdValueGroup id
1Test_0110
Test
2Test_0220Test
Subtotal 30 
3Test_0325Test2
Subtotal 25
 
Total 55 
 
NOTE: Group id is not visible in report format... it only using for group the id and calculate subtotal for the group.
 
 
 
  • Suggested answer
    Alireza Eshaghzadeh Profile Picture
    Alireza Eshaghzadeh 10,767 Super User on at
    Create a custom ER format by using group in Excel
    Hi,
    Can you elaborate about what you need assist for by providing screenshots of your model mapping and your format designer?
  • Martin Dráb Profile Picture
    Martin Dráb 222,562 Super User on at
    Create a custom ER format by using group in Excel
    Moved from D365 general forum to the Finance forum, because it seems to be about F&O and not about D365 in general. Please let me know if you disagree.

Helpful resources

Quick Links

What Motivates a Super User?

We know many of you visit the Dynamics 365 Community and Power Platform…

Demystifying Copilot with Sundar…

Industry experts answer burning questions directly from our amazing Community…

Enabling Copilot Case and Conversation…

Agents can easily recap an ongoing chat, transcribe a voice conversation…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 282,978 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 222,562 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,138

Product updates

Dynamics 365 release plans