Forum

Building An Income ...
 
Notifications
Clear all

Building An Income Statement in Power Pivot

2 Posts
2 Users
0 Reactions
517 Views
(@dormie)
Posts: 1
New Member
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
(@mynda)
Posts: 4761
Member Admin
 

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
Share: