Question: are values in pivot table?
Answer: Right-click anywhere in the PivotTable, and click Show Field List. In the PivotTable Fields list, under Values, click the arrow next to the value field. Click Value Field Settings. Pick the summary function you want, and click OK.