Forum Discussion

kenthub's avatar
kenthub
Icon for Helper I rankHelper I
8 years ago

Profit and Loss statement - help with hierarchy

I know its been asked and I have checked all the suggested articles, but I need some help!   I'm trying to get this: This image is from thebiaccountant.    The guy talks way over my head a...
Need Help
Tips and Tricks
Tutorial Requests
kenthub's avatar
kenthub
Icon for Helper I rankHelper I
8 years ago

Here is the PBIX File

 

We do utilize a good Chart of Accounts. Take a look and let me know what you think....

 

If we need to make the changes from the report we pull from NAV then that might have to be the option. 

 

Thanks all!

ImkeF's avatar
ImkeF
Icon for Community Champion rankCommunity Champion
8 years ago

To help you set up my model, you would have to provide that Chart of accounts table as well.

 

Or to be more precise: We need a table which contains the definition of which accounts go into which (sub-) totals (or account groups).

  • kenthub's avatar
    kenthub
    Icon for Helper I rankHelper I
    8 years ago

    Gotcha. How or what would you use to connect the two tables? Like the YouTube video above shows there are headings, subheads, sub-subheadings, etc.   Would it be best to associate a number linking the specific Chart of Account (Revenue, Cost of Sales, etc.) to the desired GL number? Or would you used some other method of connecting the tables?

    • ImkeF's avatar
      ImkeF
      Icon for Community Champion rankCommunity Champion
      8 years ago

       

      The connections between the tables can be seen in the sample files from my blogpost.

      If you're struggling to apply it to your data, I would need to see your tables.

      • kenthub's avatar
        kenthub
        Icon for Helper I rankHelper I
        8 years ago

        ImkeF link to your blog post?