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

[anitaberg]

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.

[v-chuncz-msft]

@anitaberg,

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

[aravindan93]

You Saved My Time.