What does Show Values As do in a pivot table?

It changes how a value field is displayed relative to other values, without adding helper columns.

Options include % of Grand Total, % of Parent Row Total, Difference From, % Difference From, Running Total In, and Rank.

It answers most 'what share is this' and 'how has this changed' questions directly inside the pivot.