In the PivotTable ribbon, create a new measure:

• Table name: F_Monthly_Sales
• Measure name: CompanyProfit
• Formula: =[Sum of Gross_Profit]-[Sum of Cost_Value]
• Formatting Category: Currency, 2 decimal places, €

Create a PowerPivot query

Your query should look like this:

Note your company profit.