Profit and Loss Statement

Hello in addition to the great visualization charts and graphs we have a need to show a financial Profit and Loss statement on our dashboard. I am using a pivot table and can get halfway to success. But the order and grouping of the rows is not ideal.

Has anyone else built a P&L statement able to share any tips/tricks? I'm not sure if it is the structure of our DB or if I just need a new drag and drop/manually organize table rows type functionality.

Thanks for any help you can provide,