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.