User Tools

Site Tools


bicn01:f5012

Analyse your Marketing Campaign

In the PowerPivot ribbon, create a new measure:

  • Table name: F_Monthly_Marketing
  • Measure name: Sum of Campaign_Profit
  • Formula: =[Sum of Gross_Profit] - [Sum of Marketing_Costs]
  • Formatting Category: Currency, 2 Decimal places, Symbol €

Create a PowerPivot query

Columns Rows Values
Calender_Month_ISO Campaign_Name Sum of Marketing_Costs
∑ Values Sum of Gross_Profit
Sum of Campaign_Profit

Apply Home → Conditional Formating → Highlight cells, greater 0.

Your report should look like this.

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