Notifications
Clear all
Power Pivot
2
Posts
2
Users
0
Reactions
302
Views
Topic starter
I am struggling to complete an income statement in Power Pivot. I can get the different categories subtotaled and the appearance to look okay, but when how do I get Gross Income, Gross Profit, Net Operating Income, and Net Income included properly? I tried building 2 different financial statement templates but I don't know how to create a relationship with my data table. My file sizes are too big to attach, but more than willing to share with someone if they can help.
Posted : 24/05/2020 5:00 pm
Hi Patrick,
Welcome to our forum!
You can create an income statement with Power Pivot and some trickery as described here.
I hope that points you in the right direction.
Mynda
Posted : 24/05/2020 8:03 pm