cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
anitaberg Regular Visitor
Regular Visitor

How to create profit and loss type report on General Ledger entries using hierarchy

 

Hi! I have worked a while to try to create a simple profit and loss or financial statement look of a report. That is something a customer wants to have to start using Power BI, instead of doing it manually in Excel.

 

The data is from Cronus International the demo company of Microsoft Dynamics Nav 2018. I have created a separate table where I mark each account to where they belong in a hierarchy. See the second print screen.

 

As you see from the first print screen I have achieved the layot in mtrix by presenting the levels of the hierarchy in rows and using the steped layout.

 

The "only problem" now is the repeating of the levels, that actually don´t have nodes all the way to level 6 in the hierarchy. In the dataset the value is just repeated to avoid to have blanks, as there is values here to show.

 

You see that avskrivninger (depreciation) , netto finanskostnader (finance costs) and skattekostnad (tax) are repeated.

 

The hierarchy is only represented by having the levels in rows, I have not set up a hierarchy elsewere.

 

QUESTION: Is there a way to supress or or avoid that skattekostnad, avskrivninger and netto finanskostnad is repeated for all the rest of the hierarchy, that should end at a higher level.

 

Skjermbilde 2018-02-21 kl. 08.33.26.pngSkjermbilde 2018-02-21 kl. 08.34.13.png

2 REPLIES 2
Community Support Team
Community Support Team

Re: How to create profit and loss type report on General Ledger entries using hierarchy

@anitaberg,

 

In the Format section of the Visualizations pane, you may try Row headers > Stepped layout and Subtotals > Row subtotals.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
aravindan93 Frequent Visitor
Frequent Visitor

Re: How to create profit and loss type report on General Ledger entries using hierarchy

You Saved My Time.