User Tools

Site Tools


bicn01:f5013

HowTo PowerPivot - How does your Salespersons perform?

Create a new measure GrossProfitRatio.

  • Table name: F_Monthly_Sales
  • Measure name: GrossProfitRatio
  • Formula: =[Sum of Gross_Profit]/[Sum of Revenue]
  • Formating: Number, 2 decimal places

Create a PowerPivot query.

Rows Values
Employee_Position Sum of Gross_Profit
Employee_Name Sum of Revenue
GrossProfitRatio
Sum of Sales_Amount

Apply Conditional Formatting → Color Shades → Green-White Color Shares

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