User Tools

Site Tools


bicn01:f5008

PowerPivot: CompanyProfit

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

Rows Values
Calendar_Quarter Sum of Revenue
Calender_Month_ISO Sum of Transfer_Price
Sum of Discount
Sum of Gross_Profit
Sum of Cost_Value
CompanyProfit

Your query should look like this:

Note your company profit.

bicn01/f5008.txt · Last modified: 2018/12/04 08:39 (external edit)