I'm creating a pivot which is basically a P&L. It will essentially show costs and revenues. There will then be a subtotal for all revenue items and cost items.
The grand total is a sum of these and is the net profit.
I want to show the net profit as a % too but have no idea how to implement this into a pivot.
Is this something I could/should be doing using power pivots?? Any suggestions or advice on how to approach this type of problem would be great.
I've attached a sample workbook.
Bookmarks