Question: how to change value to percentage in pivot table?
Answer: Select a cell in the data area of the new field you inserted (Sum of Quantity). From the PivotTable toolbar, select Field Settings (in Excel 97, select PivotTable Field). In the Name box, type % Quantity. From Show Data as choose % Of Total. Click OK.