In the PowerPivot ribbon, create a new measure:
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.