Display Data as Percentage of Total in Pivot Table
3. Go to the value box and click on sum of quantity and then on value field setting.
4. A dialog box will appear. Click on the tab Show Value As.
5. Click the drop down menu of Show Values As.In this menu select whatever percentage you want to select.
6. Final result will be like this:
You can notice that data is being shown as a percentage of total in your pivot table.