Percentage of a Specific Item

Another client sells computer hardware and then software and service plans. The sales reps have a goal to have software and service both exceed 10% of the hardware revenue. You can use the xlPercentDifferenceFrom setting to express revenues as a percentage of the Hardware product line:

' Show revenue as a percentage of hardware With PT.PivotFields("Revenue") .Orientation = xlDataField .Function = xlSum .Caption = "% of HW"

.Calculation = xlPercentDifferenceFrom .BaseField = "ProductLine" .Baseltem = "Hardware" .Position = 3 .NumberFormat = "#0.0%" End With

0 0

Post a comment