Question: how do i show the percentage of two columns in a pivot table?
Answer: Right-click one of the Units value cells, and click Show Values As. Click % of Column Total. The field changes, to show the percentage of sales for each item, within each Region column. For example, Pens were 47% of the overall sales in the East region. Top.